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

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  One clever way to transform binary numbers to BCD notation (binary-coded decimal) is the "double dabble algorithm". It can be adapted to transfo

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. A) Database system B) Operating system C) Network D) Physical Human

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 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? Our software and imaging systems supports duplex scanning, at the same time scanning both sides of a page. Program