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?

Reviews

Write a Review

Computer Engineering Questions & Answers

  Mathematics in computing

Binary search tree, and postorder and preorder traversal Determine the shortest path in Graph

  Ict governance

ICT is defined as the term of Information and communication technologies, it is diverse set of technical tools and resources used by the government agencies to communicate and produce, circulate, store, and manage all information.

  Implementation of memory management

Assignment covers the following eight topics and explore the implementation of memory management, processes and threads.

  Realize business and organizational data storage

Realize business and organizational data storage and fast access times are much more important than they have ever been. Compare and contrast magnetic tapes, magnetic disks, optical discs

  What is the protocol overhead

What are the advantages of using a compiled language over an interpreted one? Under what circumstances would you select to use an interpreted language?

  Implementation of memory management

Paper describes about memory management. How memory is used in executing programs and its critical support for applications.

  Define open and closed loop control systems

Define open and closed loop cotrol systems.Explain difference between time varying and time invariant control system wth suitable example.

  Prepare a proposal to deploy windows server

Prepare a proposal to deploy Windows Server onto an existing network based on the provided scenario.

  Security policy document project

Analyze security requirements and develop a security policy

  Write a procedure that produces independent stack objects

Write a procedure (make-stack) that produces independent stack objects, using a message-passing style, e.g.

  Define a suitable functional unit

Define a suitable functional unit for a comparative study between two different types of paint.

  Calculate yield to maturity and bond prices

Calculate yield to maturity (YTM) and bond prices

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd