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
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


describe objectivde of file organisation

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

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

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

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

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 with the following description and functional dependencies into a set of equivalent tables normalized to 3NF or BCNF. A long-standing international treaty am

prototype of a distributed information system for a national car part retail outlet chain.