Cheeky

Computers & Technology

14 October, 07:46

Write out the relation schema for each of the following relations.

a. Author

b. Book

c. Publisher

d. Member

e. Phone

You are to create the tables for a database containing the following entities. For each attribute, think about what the domains would be:

1. Author (All fields should be appropriately defined.)

2. Phone (All fields should be appropriately defined.)

3. Publisher (All fields should be appropriately defined.)

4. Book (All fields should be appropriately defined.)

5. Member (All fields should be appropriately defined.)

As well as the relationships between them.