ZuoTi.Pro
Question

2. Convert the following REA diagram to tables by applying the conversion rules described in this chapter. Customer Places Or

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

For all one to many relationship create one table for each relation

Customer

CustomerID Name Address Phone

Sale clerk, shipping clerk and cash receipts clerk have same properties, so one table Clerk is created for them. Each of the role is identified using Role.

Clerk

ClerkID Name Address Phone Salary Role

Inventory

ProductID Name Price Descreption

Relationship between take order and Inventory is many to many, so split details into two tables Order and ProductOrder as shown below

Order

OrderID OrderDate CustomerID ClerkID

ProductOrder

OrderID ProductID Quantity

Reciept

ReceiptID Cash ClerkID

Relationship between ship order and Inventory is many to many, so split details into two tables Shipment and ProductShipment as shown below

Shipment

ShipmentID OrderID ReceiptID

ProductShipment

ShipmentID ProductID ShipmentDate ClerkID
0 0
Add a comment
Know the answer?
Add Answer to:
2. Convert the following REA diagram to tables by applying the conversion rules described in this...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • At Kingston Industries, the revenue processes are conducted by five employees. The five employees are the...

    At Kingston Industries, the revenue processes are conducted by five employees. The five employees are the sales clerk, warehouse clerk, accountant 1, accountant 2, and the collection clerk. A description of their duties is as follows: The sales clerk receives customer orders by phone. She prepares a four‐copy sales order form. She files one copy, one copy goes to the warehouse clerk, one copy goes to accountant 1, and one copy is mailed to the customer. After receiving a sales...

  • At Kingston Industries, the revenue processes are conducted by five employees. The five employees are the...

    At Kingston Industries, the revenue processes are conducted by five employees. The five employees are the sales clerk, warehouse clerk, accountant 1, accountant 2, and the collection clerk. A description of their duties is as follows: A. The sales clerk receives customer orders by phone. She prepares a four-copy sales order form. She files one copy, one copy goes to the warehouse clerk, one copy goes to accountant 1, and one copy is mailed to the customer. B. After receiving...

  • Help with this problem, please. Conceptual Model: Draw an REA model with cardinalities for the operating...

    Help with this problem, please. Conceptual Model: Draw an REA model with cardinalities for the operating events, resources, and agents in the Formula One inventory acquisition/payment process. Please be sure to include cardinalities with your relationships on the relationship lines, similar to the additional attachment I'm including, thank you for all help. Please keep the resource entities on the left, and the agents on the right-hand side, with the events in the middle if you can use the additional attachment...

  • You are part of an accounting firm Advisory team that has been engaged by a client to assess how ...

    You are part of an accounting firm Advisory team that has been engaged by a client to assess how they might make their “sales to order” process more “efficient”, perhaps with the introduction of new technologies. The client has provided a written description of their business, and the process under review, as follows: HHH is a small manufacturer of university based sportswear (a highly competitive market where fast response times are prized by customers). Sales span every region of the...

  • You are part of an accounting firm Advisory team that has been engaged by a client to assess how ...

    You are part of an accounting firm Advisory team that has been engaged by a client to assess how they might make their “sales to order” process more “efficient”, perhaps with the introduction of new technologies. The client has provided a written description of their business, and the process under review, as follows: HHH is a small manufacturer of university based sportswear (a highly competitive market where fast response times are prized by customers). Sales span every region of the...

  • Heavy Equipment and Machinery Inc. Trial Balance At December 31, 2019

    What is the answer to these tables? here is all the information that had been given to me and my answers to the question that I think needs to be answered to complete the two tablesYou have been hired as a Financial Consultant by Heavy Equipment and Machinery Inc. (HEMI).  HEMI is a private corporation that has finished its first year of operations. HEMI's owners plan to list the business on the Toronto Stock Exchange  (TSE) in the next 5 years; accordingly,...

  • Please read the article and answer about questions. You and the Law Business and law are...

    Please read the article and answer about questions. You and the Law Business and law are inseparable. For B-Money, the two predictably merged when he was negotiat- ing a deal for his tracks. At other times, the merger is unpredictable, like when your business faces an unexpected auto accident, product recall, or government regulation change. In either type of situation, when business owners know the law, they can better protect themselves and sometimes even avoid the problems completely. This chapter...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT