1. Database Design Assume that you are the database developer for this task, complete the information-level design for the new database "Appointment. Monggevoeot" that satisfies the constraints and user view requirements given below. User view 1 requirement: The database should have information about Patients, Doctors, Appointments Bills and Payments. User view 2 requirements: Database system will store Patient's details such as-Patient.JD, name, phone, email and home address, Patients can make one or more appointments. However, one appointment is scheduled with only one patient. User view 3 requirements: Each doctor has an identification number and his/her name, telephone number, email and speciality should be recorded in the database. Examples for Doctor's speciality - Cardiologist, Orthopaedics, Oncologists, Urologist_etc. (Note: It is a multi-valued attribute). User view 4 requirements: It is required to keep track of Appointment number. Appgiomet date, time and reason for the appointment. Each doctor can have zero or many appointments, however each appointment is scheduled with exactly one doctor. User view 5 requirements: For each appointment one or more payments can be made; each payment may be for one or more appointments. Write down any assumptions you have made. if they are not explicitly described here. While completing the information-level design you are required to answer questions given below 1(a) (b) a. Identify and list entities described in the given case scenario. (5 Marks) b. ER diagram Add attributes to those entities and select suitable primary keys for each entity. Represent the structure of your database visually by using the entity-relationship (ER) diagram. a. If you make any assumptions about data that are not explicitly given in the problem, these must be described. b. You are required to use a software tool to create the ER diagram. You can use draw ip[2], Lucidchart (1), Visio or any other software tool to create the ER diagram. (20 Marks)