Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure given below into a dependency diagram that is in at least 3NF. Draw diagram for every level going from 1NF to 2NF to 3NF.

Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter13: Web Site Applications
Section: Chapter Questions
Problem 6E
icon
Related questions
Question

Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure
given below into a dependency diagram that is in at least 3NF. Draw diagram for every level
going from 1NF to 2NF to 3NF. 

APPOINTMENT
РК Аpp Num
FK1 Doc_EmpID
App_Date
App_Time
App PatientID
App_Name
App_Phone
App_Street
App_City
App_State
App_Zip
App_Status
DOCTOR
PK Doc EmpID
--H-
Doc Fname
Doc Lname
Doc CellPhone
Doc_EmpID: Employee ID for the doctor.
Doc Fname: Doctor's first name.
Doc_Lname: Doctor's last name.
Doc CellPhone: Doctor's cell phone number.
App Num: Syslem generaled number.
App_Date: Ihe date of the appointment.
App_Time: The time of the appointment.
App_PatientID: The ID number of the patient.
App_Name: The name of the patient.
App_Phone: The contact phone number of the patient.
App_Street: The street address for the patient.
App_City: The city the palient lives in.
App State: The state the patient lives in.
App Tip: The zip code lor ihe palient's addıess.
App_Status: The status of the appointment (pending, closed, cancelled)
Transcribed Image Text:APPOINTMENT РК Аpp Num FK1 Doc_EmpID App_Date App_Time App PatientID App_Name App_Phone App_Street App_City App_State App_Zip App_Status DOCTOR PK Doc EmpID --H- Doc Fname Doc Lname Doc CellPhone Doc_EmpID: Employee ID for the doctor. Doc Fname: Doctor's first name. Doc_Lname: Doctor's last name. Doc CellPhone: Doctor's cell phone number. App Num: Syslem generaled number. App_Date: Ihe date of the appointment. App_Time: The time of the appointment. App_PatientID: The ID number of the patient. App_Name: The name of the patient. App_Phone: The contact phone number of the patient. App_Street: The street address for the patient. App_City: The city the palient lives in. App State: The state the patient lives in. App Tip: The zip code lor ihe palient's addıess. App_Status: The status of the appointment (pending, closed, cancelled)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Normalization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning