{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

REA in class practice0

REA in class practice0 - Example DrawanREADiagram,,forJoes...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Example Draw an REA Diagram , complete cardinalities, for Joe’s revenue cycle Joe’s is a small ice cream shop located near the local university’s baseball field. Joe’s serves walk-in customers only. The shop carries 26 flavors of ice cream. Customers can buy cones, sundaes, or shakes. When a customer pays for an individual purchase, a sale transaction usually includes just one item. When a customer pays for a family or a group purchase, however, a single sale may include many different items. All sales must be paid for at the time the ice creams is served.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Example 1 solution Inventory Employee Sales Cash Receipts Cash Employee Customer (1,N) (0,N) (0,1) (1,1) (1,1) (0,N) (1,1) (0,N) (0,N) (1,1) (0,N) (1,1) (0,N) (1,1)
Background image of page 2
Example 2 The Mesa Pet Hospital is run by Dr. B. She has two employees in the office and has asked you to develop a database to help better track her data. Below is her daily activities. When new customers come to the hospital, the owner of the pet are required to complete an introductory form on the owner and the pet. When customers call to make appointments, one of the office clerks asks what kind of services they require. Dr. B sees only one pet during each appointment. If she is going to see one owner’s two pets, then two separate appointment are necessary. For each appointment, Dr. B records the pet’s weight, notes the reason for the appointment, and records her diagnosis. Depending on the diagnosis, the doctor
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}