Examine the data model and identify problems

Assignment Help Computer Engineering

Reference no: EM132088426

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.

Reference no: EM132088426

Questions Cloud

Vas deferens cause male infertility : Why would a blockage in the vas deferens cause male infertility?

Room expecting the birth of twins : Peter while in the waiting room expecting the birth of twins, became very ANXIOUS. One of the attending nurses realized that he had developed respiratory

Write two test cases for each function to make sure : Create a function sum_abs(), that takes two arguments and returns the sum of the absolute values of both arguments.

How much money does mrs smith save : Mrs Smith owns a piece of Florida real estate her mileage rate is 45 and the home has been assessed at $255,000 she has a homestead exemption

Examine the data model and identify problems : Examine the data model and identify problems with or errors in the design. In a Microsoft Word document, capture the table definitions.

Mrs smith owns a piece of florida real estate : Mrs Smith owns a piece of Florida real estate her mileage rate is 45 and the home has been assessed at $255,000 she has a homestead exemption using the base

What are the perfect squares : What are the perfect squares between 10 and 45?

Normal distribution with mean : 1. For Normal Distribution with mean = 50 and Standard Deviation = 10 convert x = 70 to z-score.

What does leadership mean to you : What strengths do you believe you have as a leader? Weaknesses? · What has been your greatest influence as a leader?

User Account

All Pages