Question: For the following SQL Database questions choose the correct response: ------------------------------------------------------------------ Question a. : A key in a relational database table i. is a minimal

For the following SQL Database questions choose the correct response:

------------------------------------------------------------------

Question a. : A key in a relational database table i. is a minimal set of attributes. ii. uniquely identifies a tuple in the table. iii. both i. and ii are correct iv. neither option i. nor option ii

------------------------------------------------------------------

Question b. :A candidate key in a relational database table

i. is a minimal set of attributes. ii. uniquely identifies a tuple in the table. iii. both i. and ii are correct iv. neither option i. nor option ii.

------------------------------------------------------------------

Question c. : A primary key defined in SQL create table statement

i. is a minimal set of attributes ii. uniquely identifies a tuple in the table. iii. is selected from a set of candidate keys. iv. All of the above are correct.

------------------------------------------------------------------

Question d. :In relational model, a relation contains

i.a set of records ii.a set of unique records. iii. either i. or ii iv. neither i. nor ii.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!