You received a unique random database specification (which pointed to this instruction page). You must follow these instructions for your received database specification. You must answer the following questions and create a normalized model in MySQL Workbench. The provided specification is different for each student. You must create the specification and ERD for the design you received. This is a CLOSED BOOK assignment, and you are not allowed to use any external information to solve it. Be sure that you use the URL that was assigned to you. Solving a different version of the assignment will result in a grade of zero for this assignment and may result in honor committee referral. Database Model Conventions You must follow these conventions when you perform your homework. Failing to follow the conventions will be penalized per each mistake and may also constitute evidence of cheating. Entity names: singular nouns (or noun phrase) written in CAPITAL LETTERS, using _ instead of space, must end with a two letter suffix with your first name and last name initials (e.g. if your name is John Doe, an entity name will be PERSON_JD) Attribute names: singular nouns (or noun phrase) written in CAPITAL LETTERS, using _ instead of space, must end with a two-letter suffix with your first name and last name initials (e.g. if your name is John Doe, an attribute name will be FIRST_NAME_JD) Relationship names: third person verbs (or verb phrase) written in lower case letters, using spaces. Do not use "has" or other generic names. Use a name that clarifies the meaning (even if contains entity names). No initials in the name. Additional conventions might be specified by your instructor (e.g. prefix the attribute names with the entity name or abbreviation) For this fictional scenario you must apply the instructions linked above. A hospital chain wants to model their appointment system. Their current appointments are kept in a spreadsheet system. All the hospitals are in similar buildings and having the same internal organization. A relevant historical fragment is provided below: Hospital Doctor Appointment Patient Fairfax Best Hospital; (999) 113-2239 D1001: Michael Jones; (999) 218-9933 9/7/2019 10:00AM Suite 2400 P10000121: Robert Brown; (999) 310-2241 9/7/2019 10:20AM Suite 2400 P10000123: Andrea Garcia; (999) 324-9267 ... ... D1002: William Miller; (999) 228-9933 10/5/2019 10:20AM Suite 3100 P10000123: Andrea Garcia; (999) 324-9267 ... ... ... ... ... Arlington Best Hospital; (998) 120-1124 D2001: Mary Johnson; (999) 235-8365 9/7/2019 10:00AM Suite 1200 P20003728: Elizabeth Brown; (999) 335-1182 ... ... 11/27/2019 8:00PM Suite 1200 P20003728: Elizabeth Brown; (999) 335-1182 D2002: Patricia Rodriguez; (999) 241-0043 ... ... 1/24/2019 8:30AM Suite 2400 P20003728: Elizabeth Brown; (999) 335-1182 ... ... ... In addition the following business rules were identified: A doctor works in one or more hospitals. A hospital has many doctors. A doctor uses the same suite for all the appointments. A suite is used by several doctors. A doctor has many patient appointments. An appointment is for a given doctor. A patient has many doctor appointments. An appointment is for a given patient. The first names and last names are having at most 25 characters each. Middle names are not stored CREATE AN ERD DIAGRAM IN MYSQL WORKBENCH