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
• TITLE_ID
• DATE_OF_BORROWING

• DATE_OF_RETURNING

  1. Are these tables respect the 3NF Database Normalization?
  2. What if 2 authors work together for the same title?
  3. The column Addresss should have it's own table?
  4. 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 one entry in HISTORY table. Is this a good idea? Do I brake any rule? Should I have instead one single BORROWING table with a DATE_OF_RETURNING column?