First Normal Form - Identify all rows

• Create a table with all rows identified for your data, eliminating the repeating value.
• Include the table or a screenshot of the table.
• First Normal Form - Identify all columns
  • Identify all the attributes (columns) in your data table. At this step, you must keep all the attributes in a single table.
  • Be sure you divide the composite attributes. You must divide the composite attributes based on the typical use of such data. Try to anticipate how the customer will use the information.
  • Include the table or a screenshot of your table.
• First Normal Form - Dependencies
  • Identify the primary key and its dependencies, partial dependencies and transitive dependencies.
  • Draw the dependency diagram using any graphical editor (Powerpoint, Word, ...). Mark the PK with a different color. Mark distinctly the partial dependencies from the transitive dependencies.
  • At this step you will have a single entity with all the attributes in the dependency diagram.
  • Include the diagram in your report. You can include a picture of it.
  • You can write the name of the attributes vertically.
• Second Normal Form
• Convert the first normal form in second normal form. Draw the new dependency diagram. Include the 2NF diagram.
• Third Normal Form
• Convert the second normal form in third normal form. Draw the new dependency diagram. Include the 3NF diagram.
• Improved Third Normal Form
• How you can further improve the obtained diagram? Provide at least one improvement idea and improve the diagram based on it.
• ERD
• Draw the ERD using MySQL Workbench. Include a screenshot with the ERD.  

Transcribed Image Text:

Hospital Doctor Appointment Patient D1001: Michael Jones (999) 2189933) 9/7/2019 10:00AM Suite P10000121: Robert Brown (999 2400 3102241) 9/7/2019 10:20AM Suite P10000123: Andrea Garcia (999 2400 3249267) Fairfax Best Hospital (999 1132239) D1002: William Miller (999 2289933) 10/5/2019 10:20AM Suite P10000123: Andrea Garcia (999 3100 3249267) 1200 9/7/2019 10:00AM Suite P20003728: Elizabeth Brown (999 3351182) D2001: Mary Johnson (999 2358365) Arlington Best Hospital (998 1201124) 1200 11/27/2019 8:00PM Suite P20003728: Elizabeth Brown (999 3351182) D2002: Patricia Rodriguez (999 2410043) 1/24/2019 8:30AM Suite P20003728: Elizabeth Brown (999 2400 3351182) In addition the following business rules were identified: A doctor works in a single hospital. A hospital has many doctors. A doctor uses different suites for 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 23 characters each. Middle names are not stored. Hospital Doctor Appointment Patient D1001: Michael Jones (999) 2189933) 9/7/2019 10:00AM Suite P10000121: Robert Brown (999 2400 3102241) 9/7/2019 10:20AM Suite P10000123: Andrea Garcia (999 2400 3249267) Fairfax Best Hospital (999 1132239) D1002: William Miller (999 2289933) 10/5/2019 10:20AM Suite P10000123: Andrea Garcia (999 3100 3249267) 1200 9/7/2019 10:00AM Suite P20003728: Elizabeth Brown (999 3351182) D2001: Mary Johnson (999 2358365) Arlington Best Hospital (998 1201124) 1200 11/27/2019 8:00PM Suite P20003728: Elizabeth Brown (999 3351182) D2002: Patricia Rodriguez (999 2410043) 1/24/2019 8:30AM Suite P20003728: Elizabeth Brown (999 2400 3351182) In addition the following business rules were identified: A doctor works in a single hospital. A hospital has many doctors. A doctor uses different suites for 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 23 characters each. Middle names are not stored.