This design is a relational data model for a library in a small town . The library contains books, videos, newspapers, and magazines that can be...

This design is a relational data model for a library in a small town. The library contains books, videos, newspapers, and magazines that can be checked out. It also contains reference books, videos, magazines, and newspapers that cannot be checked out.

As a group, examine the data model and identify problems with or errors in the design. In a Microsoft Word document, capture the table definitions, definitions of (key and non-key) fields, and the relationships in the diagram when looking for problems and errors. These project components are further described as follows:

• The table definitions
• The definitions of the primary key fields
• The relationships in the diagram