Give a suitable example of a table with sample data and illustrate Pri

Give a suitable example of a table with sample data and illustrate Primary and Candidate keys in it.

Answer»

A table may have more than one such attribute or a group of an attribute that identifies a row/ tuple uniquely, all such attribute(s) are known as Candidate keys. Out of the Candidate keys, one is selected as Primary key.

Table: Stock

ID	Item	Qty
101	Pen	560
102	Pencil	780
104	CD	450
109	Floopy	700
105	Eraser	300
103	Duster	200

Id = Primary key Id and Qty = Candidates Keys

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.

Give a suitable example of a table with sample data and illustrate Primary and Candidate keys in it.

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment