Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw a COMPUTER GENERATED ERD of the given scenario. Mention your brain storming as well before the drawing. Tom is starting a dental practice in

Draw a COMPUTER GENERATED ERD of the given scenario. Mention your brain storming as well before the drawing. Tom is starting a dental practice in a small town. He will have a dental assistant, a dental hygienist, and a receptionist. He wants a system to manage the appointments.

When a patient calls for an appointment, the receptionist will check the calendar and will try to schedule the patient as early as possible to fill in vacancies. If the patient is happy with the proposed appointment, the receptionist will enter the appointment with the patient name and purpose of appointment. The system will verify the patient name and supply necessary details from the patient records, including the patient's ID number. After each exam or cleaning, the hygienist or assistant will mark the appointment as completed, add comments, and then schedule the patient for the next visit if appropriate.

The system will answer queries name and by date. Supporting details from the patient's records are displayed along with the appointment information. The receptionist can cancel appointments. The receptionist can print out a notification list for making reminder calls 2 days before appointments. The system includes the patient's phone numbers from the patient records. The receptionist can also print out daily and weekly work schedules with all the patients. THE DIAGRAM MUST BE COMPUTER GENERATED, DON'T ANSWER OTHERWISE PLEASE.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data And Databases

Authors: Jeff Mapua

1st Edition

1978502257, 978-1978502253

More Books

Students also viewed these Databases questions

Question

Prepare an ID card of the continent Antarctica?

Answered: 1 week ago