Which of the following statements is TRUE? A table may have ______

Select one:

a. many primary keys and many foreign keys

b. one primary key and many foreign keys

c. many primary keys and one foreign key

d. one primary key and one foreign key

A _______________ is a textual representation of the database tables where each table is listed by its name followed by the list of its attributes in parentheses.

Select one:

a. logical schema

b. relational dictionary

c. data dictionary

d. relational schema

Suppose there is a Many-to-One relationship between the Student and the Department entities. How is this relation type resolved in the relational model? Note: A student enrolls in one department, but there may be many students in a department.

Select one:

a. Primary Key of the Department table is added to the Student table as a Foreign Key.

b. One of the sides receives the other sides Primary Key as a Foreign Key.

c. Such relationships do not need to be resolved.

d. Primary Key of the Student table is added to the Department table as a Foreign Key.

Which of the following is not a valid constraint that could be used in a CREATE TABLE statement?

Select one:

a. CHECK

b. UNIQUE

c. NOT NULL

d. DEFAULT