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

--

draw the class diagram and relation scheme for a version of this database in 3NF. If you need to denormalize, state the reason,.