Part:1
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
Individual section: Individually, report your group analysis describing the errors or problems in a 2- to 3-page document in APA format. Then, explain in words how to make changes to the diagram to fix those errors or issues.
Part:2
The small town mentioned in Part 1 is growing and now has three library branches from which residents can borrow items. Each branch has a full-time supervisor and both full- and part-time employees. All non-reference media can be checked out, but if the media is not returned by the due date a warning is sent and the member is charged 10 cents for each day the item is late.
The library database is for staffing and circulation. You are not responsible for storing information about computers or computer usage. Library maintenance is also outside the scope of this database.
In this part of the Group Project, add to or edit and enhance the corrected diagram from Part 1 of the Group Project to include this additional information. Then, describe the normalized tables as shown in the normalization video showing primary keys, foreign keys, and data types. This portion of the Group Project is also completed and submitted individually.
Begin with the corrected diagram from Part 1, using Word or any software that allows you to enhance the diagram. You may also hand draw the UML and use a scanner or digital camera to capture the image.