Assignment Instructions: You are a member of the team developing the new Electronic Health Record database for a small rural clinic. The initial ERD for the appointment function of the database is shown below. FIGURE P6.1 APPOINTMENT ERD FOR PROBLEMI TOINTMENT PK APP Mum FKI Doc_Cipla DOCTOR A. .pl PM me foorid 30 ------- Ao Nano LOE mame App Fhore LIOL Un APAT APRUCHS Apple pap Nor Erpus Empowder co Los FruimDorul M. lloc Lucr's I Bloc Caliphano Doc's cellphone number Ane Mum Swan Warunt. AN Dw: Tanaw ito nainen An Tim The time of the Art App_Parim Thambon at the patial App Home Theam of the police w AP Phone: The plane bolha. PPPSH: The deter the past Chy: clythe tant lives in App Stato: These thpallontos in App Lix The dip de fiets. App Stue: The date of the appointment ording dond, muce 2. Using your Normalized attributes, create a data dictionary to define each attribute. Each table/entity MUST be defined individually. If you use Microsoft Excel (preferred), create a new Worksheet (tab) for each table/entity. If you use Microsoft Word, create a new table and/or page for each entity/table. . At a minimum, your data dictionary must include the following: Field Name Field Description: a short description of what the field will be used for or any specific instructions to the user on how to enter data Data Type: Text (alphanumeric values such as a last name or a street address), Numeric (numbers that can be used in a calculation), Date/Time, Yes/No, Currency Format: A-Z, 0-9, MM-DD-YYYY, M/F/U, etc. Field Size: Maximum number of characters Range: 0 - 125 Required: Yes or No . . If you are unsure of how to answer any of the items for a particular field, conduct some research online to find out what a typical answer might be for that field. If the item does not apply to that particular field, you may leave it blank or put N/A. Submit your completed assignment (diagram & data dictionary) using the assignment link in Moodle. The following file types will be accepted: .docx, .doc, .pptx, .ppt, .xlsx, .xls, .pdf