Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data ModelingFixed Asset Procedures Classic Restorations specializes in the sale of original and reproduction restoration parts for classic sports cars. Their information system comprises manual

Data ModelingFixed Asset

Procedures

Classic Restorations specializes in the sale of original and reproduction restoration parts for classic sports cars. Their information system comprises manual procedures supported by stand-alone PCs located in various departments. The companys fixed assets procedures are described next.

A department manager requiring an item creates a purchase order, which is sent to the supplier. The supplier delivers the asset to the receiving clerk, who prepares a receiving report. Each week, the fixed asset department clerk reviews the fixed asset receiving report summary and creates a fixed asset inventory record for each receipt. The fixed asset clerk maintains the inventory records and depreciation schedules. The vendor subsequently submits an invoice to the AP department clerk, who creates an invoice record. The clerk reconciles the invoice against the receiving report and purchase order and then creates a payment obligation to be paid at a future date, depending on the terms of trade. On the due date, a check is automatically prepared and sent to the vendor, and the payment is recorded in the check register. At the end of each day, a payment summary is sent to the AP manager for review.

Required

Assume that the manual system described is to be automated using a relational database system. Prepare the following models:

  • a) An entity-level data model containing only entities and showing the cardinalities between them (no attributes are required), which will support the tasks and user views depicted in the description.
  • b) A normalized model with attributes, keys, and cardinalities.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, And Terry D. Warfield

13th Edition

9780470374948, 470423684, 470374942, 978-0470423684

More Books

Students also viewed these Accounting questions