Exercise: More Normalization

Review the following tables then answer the questions at the end of the assignment.

AUTHOR table

Author_ID, PK

First_Name

Last_Name

TITLES table

TITLE_ID, PK

NAME

Author_ID, FK

DOMAIN table

DOMAIN_ID, PK

NAME

TITLE_ID, FK

READERS table

READER_ID, PK

First_Name

Last_Name

ADDRESS

CITY_ID, FK

PHONE

CITY table

CITY_ID, PK

NAME

BORROWING table

BORROWING_ID,PK

READER_ID, FK

TITLE_ID, FK

DATE

HISTORY table

READER_ID,FK,PK

TITLE_ID,FK,PK

DATE_OF_BORROWING

DATE_OF_RETURNING

Are these tables in 3^rd Normal Form (3NF)? Why or why not?

What if two authors work together on the same title?

Should the column ADDRESS in the READERS table have its own table? Why or why not?

When a reader borrows a book, I make an entry in BORROWING table. After he returns the book, I delete that entry and I make another entry in the HISTORY table. Is this a good idea? Do I break any rules? If so, which ones? Should I have instead one single BORROWING table with a DATE_OF_RETURNING column? Why or why not?