Domain constraints, Database Management System

Domain Constraints

Domain constraints are primarily formed for defining the logically correct values for an attribute of a relation. The relation allows attributes of a relation to be confined to a range of values, for instance, values of an attribute age can be restricted as Zero to 150 or a definite type like integers, etc.

                                                      REDUNDANCY AND ASSOCIATED PROBLEMS

Let us take the subsequent relation STUDENT

Enrolment no

Sname

Address

Cno

Cname

Instructor

Office

050112345

Rahul

D-27, main Road

Ranchi

MCS-011

Problem

Solution

Nayan

Kumar

102

050112345

Rahul

D-27, Main Road

Ranchi

MCS-012

Computer

Organisation

Anurag

Sharma

105

050112345

Rahul

D-27, Main Road

Ranchi

MCS-014

SSAD

Preeti

Anand

103

050111341

Aparna

B-III, Gurgaon

MCS-014

SSAD

Preeti

Anand

103

                                                                           Figure: A state of STUDENT relation

The above relation satisfies the properties of a relation and is said to be in first normal form (or 1NF). Theoretically it is convenient to have all the information in one relation as it is then likely to be simpler to query the database. But the relation over has the following undesirable kinds:

Posted Date: 3/7/2013 1:41:24 AM | Location : United States







Related Discussions:- Domain constraints, Assignment Help, Ask Question on Domain constraints, Get Answer, Expert's Help, Domain constraints Discussions

Write discussion on Domain constraints
Your posts are moderated
Related Questions
What is assertion? Mention the forms available. An assertion is a predicate expressing a condition that we wish the database always to satisfy. Domain integrity constraints.

Write the motivations led to development of OO-DBMS? 1.  Programmer frustration with RDBMSs. 2.  Requirement for special features.

How external/conceptual mapping and conceptual /internal mapping is performed

List and also explain the dissimilar stages of DDLC ?

Define average seek time. The average seek time is the average of the seek times, calculated over a sequence of random requests.

How can we Classify the operations on classes  This step fundamentally means all three models functional, object and dynamic (studied in last section) must be combined so that

Automated system for appointment with sms and call confirmation with service providers and user has to be initiate automatically. After selecting time and date to use service, s

What is an object ID? Each class-derived table has an ID for primary key, one or more object IDs form primary key for association derived tables. An object ID is equivalent dat

In tuple relational calculus P1 → P2 is equivalent to ? A In tuple relational calculus P1→  P2 is equivalent to ¬P1 V P2. (The logical implication expression A  B, meaning

Example:  //REVOKE ALL ON EMP FROM MCA12;                              (All permissions will be cancelled) You can also cancel only some of the permissions. Drop: A user-