Take Assessment: Exercise 1
Relational Databases
Design the following two tables and turn in your submissions in an HTML file named BookPublisher.html.

BOOK:

Primary Author

Title

ISBN

PublisherID

Edition

Date of Publication

Price

Book Description

PUBLISHER:

PublisherID

Name

Address

Part I

1.      Identify the keys in your tables as follows. For this exercise, ignore the performance considerations while choosing your keys.

1.      For each table, indicate the Primary Key(s) (PKs). If there is no PK, state so. Fully justify your answer.

2.      For each table, indicate the Alternate Key(s) (AKs). If there is no AK, state so. Fully justify your answer.

3.      For each table, identify the Foreign Key(s) (FKs) and the integrity constraints. Fully justify your answer.

2.      List all columns of your tables, and the domains (the data types and formats) of these columns. Fully justify your answer.

In an HTML table, list at least four rows with valid values in each of the tables. Turn in your submission in a file named BookPublisher.html.

Part II

Write SQL statements as specified below. You may find t

[1] [2] [3] 下一页