Relational constraints, Database Management System

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







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
Related Questions
Advantages And Drawbacks Of Ddbms  There are various reasons for building distributed database systems, with sharing of data, reliability and availability, and speedup of query

Views in relational algebra:   1. Basic expression contains either  a) A relation in the database. b) A constant relation. 2.  General expressions are madde out of sma

Explain the systems development life cycle. This is the traditional method to develop, maintain, and replace information systems that contains the project identification and se

List any eight applications of DBMS. a) Universities b) Airlines c) Banking d) Credit card transactions e) Tele communication f) Sales g)Finance h) Manufac

A file manipulation command that extracts some of the records from a file is called ? A file manipulation command that extracts some of the records from a file is called SELECT

for the following business rules . Identify all entities, attributes, relationships, primary keys, cardinalities and constraints where appropriate 3. (9) An art museum owns a larg

Preliminary entities and attributes of human resourse management database management system

Data Base Management System 1. Draw the Architecture of MySQL and explain about its subsystems briefly. 2. Elaborate with the help of an example the concept of Primary key a

How Relational Calculus is different from Relational Algebra? What do understand by TRC queries and DRC queries?  Ans: Relational calculus contain two calculi, the tuple relati

What is an Index? An index is a small table having only two columns. The first column has a copy of the primary or candidate key of a table and the second column having a set o