REA in class practice0

REA in class practice0 - Example

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 DocumentRight 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 
Background image of page 3

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

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

This note was uploaded on 10/25/2011 for the course AIS 141 taught by Professor Yanxiong during the Fall '10 term at CSU Sacramento.

Page1 / 18

REA in class practice0 - Example

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online