1. Your team has to design a database to manage data for a dentist who runs a small office employing himself, three hygienists, and a receptionist. At the office they have a commercial billing system to handle payments and insurance, but appointments for office visits are currently written on a paper form similar to the sample shown below. The appointment form currently tracks only the patient name, the primary procedure to be performed (cleaning, X-ray, filling, and so on), and which employee performs the procedure. The dentist and his staff would like to store additional details, which includes the list of all the dental procedures performed at the office, the estimated fee for each procedure (base fee), the estimated time for performing each procedure (base time), and the estimated insurance coverage. The base fees and estimated times for procedures should be stored along with other information regarding procedures. However, the insurance amounts paid by patients for procedures performed are highly variable as they depend upon the type of insurance the patient has, thus, the reception who can get estimates from the billing system will enter them. The database needs to store patient's phone number and e-mail address, and record how s he wants to be notified regarding appointments. Normalize the given user view into a set of 3NF relations for this scenario using the normalization process discussed in class. (20 points) Notes: All individuals (including the dentist working a the dental clinic are considered employees. For each employee, the office needs to store at least the following data: name, address, date hired, phone, job title, and salary. For each patient, it is necessary to store at least the patient's name, address, phone, e-mail, and appointment notification method For each procedure, at least store procedure name, procedure description, base fee for the procedure and estimated time (base time) to complete the procedure. Actual fee charged to a patient for a procedure may be different from the base fee for that procedure, thus, actual fee charged to a patient for a procedure during an office visit must also be stored. Employees may need to add comments regarding procedures performed on a patient during a visit, especially if the actual fee charged to a patient for a procedure is different from the base fee for the procedure. Actual time required to complete a procedure during an office visit must also be stored as it can be different from the estimated time for the procedure Amount paid by the patient's dental insurance for each procedure during an office visit needs to be stored Each patient appointment (office visit) is with one employee (i.e each appointment recorded is associated with one employee and one patient). During an appointment the employee attends to only one patient. Employee with whom the patient has an appointment performs all procedures on the patient during the office visit Each patient can schedule several appointments over a time period An employee has one job title, but there can be more than one employees with a particular job title (e.g., there are multiple hygienists at the dental clinic). Employee job code functionally determines job title