Question: GOAL: Jim wants to store the data items listed below about Waren's sale of inventory. Identify the class/entity to which the data items listed below

GOAL: Jim wants to store the data items listed
GOAL: Jim wants to store the data items listed below about Waren's sale of inventory. Identify the class/entity to which the data items listed below belong (there are 4 classes), 1. Create a UML Diagram (resembles Figure 3.2 in the text) organized in a REA pattern, 2. Assign the data items to the appropriate classes and identify the primary and foreign keys (in a table similar to page 2), 3. Implement a database from the class diagram (in tables similar to page three). Required: Complete each of the numbers 1-3 above in one Excel Workbook with three worksheets titled: UML Diagram (blue tab), Tables (green tab), Database (red tab) Data Items: item number date of sale customer number customer address customer name sale price quantity sold employee number employee name terms description quantity on hand credit limit cost invoice number 1. Build a UML Diagram that identifies (Challenge: see if you can use shapes [Insert>Illustrations>Shapes] in Word to help you build the diagram): a. Classes - REA patterns b. Associations Insert c. Multiplicities

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!