Relational and E-R Model

There are three types of constraints on relational database that have:

• DOMAIN CONSTRAINT
• PRIMARY KEY CONSTRAINT
• INTEGRITY CONSTRAINT

 

Posted Date: 3/6/2013 5:24:54 AM | Location : United States

Ask an Expert

Related Discussions:- Relational constraints, Assignment Help, Ask Question on Relational constraints, Get Answer, Expert's Help, Relational constraints Discussions

Write discussion on Relational constraints
Your posts are moderated

Write your message here..

Related Questions

Related fields in a database are grouped in which form, Related fields in a... Related fields in a database are grouped in which form? Related data fields in a database are grouped to form a data record. (A record is a collection of related fields)

Column constraints, Column Constraints: NOT NULL, UNIQUE, CHECK, PRIMARY K... Column Constraints: NOT NULL, UNIQUE, CHECK, PRIMARY KEY, DEFAULT, REFERENCES, On  delete  Cascade :  Using  this  key  whenever  a  parent  row  is  removed  in  a referenced

What are the types of reference, What are the types of reference?explain it... What are the types of reference?explain it with suitable examples? Object oriented language given the ability to refer the object attribute of the type can be referred to the s

Define mysql_fetch_object(), What are the differences among MySQL_fetch_arr... What are the differences among MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()? Mysql_fetch_object returns the result from the database like objects while mysql

Define radix conversion method, Define Radix conversion method  One cle... Define Radix conversion method  One clever way to transform binary numbers to BCD notation (binary-coded decimal) is the "double dabble algorithm". It can be adapted to transfo

Er schema, Consider entity type Employee with attributes empNumber (this is... Consider entity type Employee with attributes empNumber (this is unique), empName, and the year when he/she was hired. An employee can either be a technical employee, a marketing e

Mention the several levels in security measures, Mention the several levels... Mention the several levels in security measures. A) Database system B) Operating system C) Network D) Physical Human

Define the five basic operators of relational algebra, Define the five basi... Define the five basic operators of relational algebra? Five basic operators of relational algebra are: 1. Union (∪∪∪∪) - Selects tuples which are in either P or Q or in both

Explain the functions trim-length-count in oracle, Explain the following fu... Explain the following functions of Oracle with suitable examples: (i) To_Char( ) (ii) Count( ) (iii) Trim( ) (iv) Length( ) Ans: (i) To_char( ): The TO_CHAR function conver

Can you scan double-sided documents and remove blank pages, Can you scan do... Can you scan double-sided documents - and remove blank pages? Our software and imaging systems supports duplex scanning, at the same time scanning both sides of a page. Program