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

Data control, Data Control The data control mostly refers to commands that... Data Control The data control mostly refers to commands that permit system and data privileges to be passed to several users. These commands are usually available to database admi

East Coast Aquarium Relational Database, East Coast Aquarium Relational Dat... East Coast Aquarium Relational Database

Thid, describe objectivde of file organisation describe objectivde of file organisation

Design and implement a database system, Safe Banking is a Canberra based cr... Safe Banking is a Canberra based credit union, which has several branches around Canberra and Queanbeyan. YOU have taken over Safe Banking. YOU need to create a database that organ

Data control, Identify the need and use of data control through problem sol... Identify the need and use of data control through problem solving, illustration

Computer, 1. Will you advise that your organization uses open source softwa... 1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development

Tuples-attributes , Consider a relation s over the attributes A and B wit... Consider a relation s over the attributes A and B with the following characteristics: 5,000 tuples with 10 tuples per page A 2-level B+ tree index on attribute

Define clause in sql to specify query result must be sorted, The clause in ... The clause in SQL which specifies that the query result should be sorted in ascending or descending order based upon the values of one or much more columns is Ans : Order by

Decompose the table - 3nf or bcnf, Decompose the table with the following ... Decompose the table with the following description and functional dependencies into a set of equivalent tables normalized to 3NF or BCNF. A long-standing international treaty am

Design and building a distributed information system, prototype of a distri... prototype of a distributed information system for a national car part retail outlet chain.