Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For the Appointments DB, submit a properly normalized ERD in class standard ERD format. Current incorrect (not properly normalized) Appointments ERD: APPOINTNENT PK App Num

For the Appointments DB, submit a properly normalized ERD in class standard ERD format.

Current incorrect (not properly normalized) Appointments ERD:

image text in transcribed

APPOINTNENT PK App Num FK1 Dcc EmpID App Date App Time App_PatientIDoH App Name App Phono App Street App City App State App Zip App Status PK Doc EmpID Doc Fhame Doc_Lname Doc CellPhone Doc EmpID: Empleyee ID for the doctor Doc Fname: Dotor's first name Doc Lnane: Doctor's lad name. Doc CellPhene: Dector's cell phone umbe. App Num: System-generated number App Date: The date of the appcintment App_Time: The time of the app intment. App PatienlD: The id number of the patient. App Nama: 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 patient lives in. App State: The state the pationt livos in. App Zlp: The zlp code for the patlent's addiess. App Status: The status of the appointment (pending, closed, cancelled)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Datacasting How To Stream Databases Over The Internet

Authors: Jessica Keyes

1st Edition

007034678X, 978-0070346789

More Books

Students also viewed these Databases questions

Question

News Story 16: More on TV Violence.

Answered: 1 week ago