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.
Quick Reply
