Question

Overview

The purpose of this assignment is to give you experience designing a database and building an Entity Relationship Diagram in a business scenario. Submit all tasks in one document. Include headings in your document.

The organization is a dentist's office. When new patients are seen for the first time, they complete a patient information form that asks for their name, address, phone number, and brief medical history, which are stored in the patient information file. When a patient calls to schedule a new appointment or change an existing appointment, the receptionist checks the appointment file for an available time. Once a good time is found for the patient, the appointment is scheduled. If the patient is a new patient, an incomplete entry is made in the patient file; the full information will be collected when the patient arrives for the appointment. Because appointments are often made far in advance, the receptionist usually mails a reminder postcard to each patient 2 weeks before the appointment.

Consider the information needed for the patient billing system:

• Patient information - The system should be able to retrieve their contact information as well as their age, blood type, occupation, employer information, and insurance carrier information.

• Insurance carrier information -The system should be able to retrieve the number of patients on plan and the carrier's contact information.

• Dentist information - The system should be able to retrieve information about the dentist.

Instructions

After completing the learning activities for this module, use what you have learned to complete this assignment:

1. Create a Class diagram. Draw a conceptual class diagram with a minimum of 7 classes.

2. Create an Entity Relationship Diagram (ERD). Include a minimum of 7 entities and 50 attributes.

3. Create a CRUD Matrix.

Answer 1

PFA the details for Class Diagram and Entity Relationship Diagram.