Exam 17: Database Design Using the Rea Data Model

A dental office employs three dentists and five dental hygienists.One of the dentists is a very recent dental school graduate and can't yet see patients on her own until she passes boards and obtains a license.Dentists perform all procedures personally,except for regular cleaning and x-rays,which are performed exclusively by dental hygienists.Three of the five dental hygienists perform only regular cleaning and x-rays.The other two hygienists each assist a specific dentist during procedures,as well as performing regular cleaning and x-rays.One of the hygienists will be assigned to the new dentist when she begins seeing patients.Hygienists usually 'shadow' other hygienists and dentists for two weeks prior to seeing patients. Patients schedule appointments directly with dentists and hygienists,depending on the type of dental service needed.Patients do not have to choose a dentist until they need service other than routine cleaning or x-rays.Patients are assigned to a specific dental hygienist when they schedule their first appointment.The customer master file has 549 records.Diagram the agents described,relationships between agents,and the cardinality pairs for each relationship.

Helge Autoparts sells new and refurbished auto parts exclusively to auto dealers.Helge purchases inventory from distributors at trade conventions.Each time Helge makes a purchase,the company records the suppliers name,address,date,specific items purchased,price paid for each,and the total amount spent.Helge later researches the inventory items to set the customer price.The company assigns an inventory number to each item purchased and records the customer price for each item.Helge buys price tags and display supplies from Alwin Incorporated,a company that sells them at all trade conventions.All inventory and supplies purchases are immediately paid for with cash or with checks from a bank account in Helge's name.All cash received from sales are also deposited to the same bank account.Several times a year Helge rents display space at dealer conventions.A deposit is always required,and the entire fee is due the day the convention starts.Helge records the deposit and final payment,along with the convention's name and address,in the same worksheet on which purchases of inventory and supplies are recorded. Consider Helge's processes regarding the purchasing inventory and supplies,renting display space,and paying for purchased items.A well-designed REA diagram would

The "get" event represents an activity which

Each event in an REA model will in most cases have at least one ________ agent and one ________ agent involved with the event.

Every citizen in the United States has one social security number,but no two citizens have the same social security number.Thus,the cardinality that exists between social security numbers and citizens is

Relationships that affect the quantity of a resource are sometimes referred to as ________ relationships.

It is industry standard to model relationships as ________ in entity-relationship diagrams.

Assume that you are looking at a REA diagram that depicts only one event.Which of the following must be on the REA diagram?

Describe what is a E-R diagram and provide an example.

Explain specifically what is meant by the following statement: "Accountants can and should participate in all stages of the database design process."