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

Assignment topic, assume we have the following apllicationthat model sccer ... assume we have the following apllicationthat model sccer team the games they play and the players inv each teamin the design we want to capture

Data cube, Data slice explanation Data slice explanation

Normalization database, I need some help with my normalization database hom... I need some help with my normalization database homework.

Entity database, what is entity in database system? what is entity in database system?

What is authorization graph, What is authorization graph? Passing of au... What is authorization graph? Passing of authorization from single user to another can be shown by an authorization graph.

What are advantages of object models, What are advantages of object models?... What are advantages of object models? Object models are efficient for communicating with the application experts and reaching a consensus about the significant aspects of the p

Entity identifier key attributes, An entity type usually has an attribute w... An entity type usually has an attribute whose values are distinct for every individual entity in the collection. Such an attribute is known as a key attribute and its values can be

Exclusive lock, Exclusive lock It is asked for by a transaction on... Exclusive lock It is asked for by a transaction on a data item that it wants to update. No other transaction can put either a shared lock or an exclusive lock on a dat

Define lock, Define lock? Lock is the most common used to execute the r... Define lock? Lock is the most common used to execute the requirement is to permit a transaction to access a data item only if it is currently holding a lock on that item.

Explain clustering file organization, Explain Clustering file organization ... Explain Clustering file organization (i) Determine if a record of file is physically ordered on a nonkey field - that does not comprise a different value for each record - that