Question: 1. A foreign key can be a. an attribute that is a primary key of another table. b. an attribute that is a primary key
1. A foreign key can be
a. an attribute that is a primary key of another table.
b. an attribute that is a primary key of the same table.
c. either a. or b.
d. neither a. nor b.
2. A key in a relational database table
a. is a minimal set of attributes.
b. uniquely identifies a tuple (record) in a relation table
c. both a. and b.
d. neither a. nor b.
3. The reason why a database table is in the second normal form (2NF), but not in the third form (3NF) is because:
a. There is a non-prime attribute that is transitively dependent on the key of the table.
b. There is a one-to-many relationship embedded in the table.
c. both a. and b.
d. neither a. nor b.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
