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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started