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

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!