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 a view?  Make a view of EMP table named DEPT 20, to display the employees in department 20 and their annual salary.  Ans:  View is a virtual table that does not consist

UNION If R1 and R2 are two union compatible relations then R3 = R1 ∪ R2 is the relation having tuples that are either in R1 or in R2 or in both. In case, R3 will have tuples

Using the concepts defined previous, we have identified that strong entities in COLLEGE database are FACULTY, STUDENT, COURSE and DEPARTMENT. This database also has one weak entity

List the requirements needed to design a trigger. The requirements are:- Specifying when a trigger is to be implemented. State the actions to be taken when the trigger im

It is mandatory that for every table in the LDB hierarchy there should exist one GET statement in the report. False.  It is not essential.

What is self-transition? If there is a transition which goes back to same state, it is known as "self- transition." With a trigger action exit action would be executed f

Eliminate Columns Not Dependent On Key The Employee Relation satisfies - First normal form - As it has no repeating groups. Second normal form - As it do not have multi-a

Data Warehousing & Mining 1. What is the concept of knowledge discovery in database? 2. Describe the following types of Multidimensional Data Models. • Stars, Snowflakes and

we need example of 2phase locking

Differance between internal and external schema? Internal and external schema: Internal Schema • Describes the physical storage structure • Uses a physical data model External