Define domain with respect to database. Give an example. – InterviewSolution

InterviewSolution

1.

Define domain with respect to database. Give an example.

Answer»

A domain is a pool of values from which the actual values appearing in a given column are drawn.

For example, The values appearing in the Supp# column of both the suppliers' table and the Shipment table are drawn from the same domain.

Shipment

Supp#	Item#	Qty
S1	12	10
S1	13	20
S2	14	30
S2	15	40
S3	16	50
S4	17	60

Supplier

Supp#	Status	City
S1	Haldiram	Delhi
S2	Parle	Jaipur
S3	Bakers	Banglore

Discussion

No Comment Found

Related InterviewSolutions

Define query in the context of database.
Give one advantage of using primary key.
What is the significance of a primary key?
Which of the following is not the main building block of a database? (a) Lists (b) Queries (c) Reports (d) Forms
Write the significance of a foreign key.
What is the default extension of OO.o not zero BASE database?
What are the main purposes of a database system?
Define RDBMS.
Observe the following PARTICIPANTS and EVENTS table carefully and write the name of the RDBMS operation which will be used to produce the output as shown in RESULT? Also, find the Degree and Cardinality of the RESULT.PARTICIPANTSNO.Name1Aruanabha Tariban2John Fedricks3Kanti DesaiEVENTSEVENTCODEEVENTNAME1001ITQuiz1002Group DebateNo.NameEVENTCODEEVENTNAME1Aruanabha Tariban1001ITQuiz1Aruanabha Tariban1002Group Debate2John Fedricks1001ITQuiz2John Fedricks1002Group Debate3Kanti Desai1001ITQuiz3Kanti Desai1002Group Debate
Discuss the components of a database.