Answered step by step
Verified Expert Solution
Question
1 Approved Answer
App_Time PatientID PatientName PatientPhone PatientAddress PatientEmail Insurance_companyname Insurance_policy_number Insurance_claimaddress Doc_EmpID Doc_Fname Doc_Lname Doc_Office SymptomDecription App_Status 10am 300330 Tom, White 123-456 2394 Pooz Street, Corvallis, OR,
-
App_Time PatientID PatientName PatientPhone PatientAddress PatientEmail Insurance_companyname Insurance_policy_number Insurance_claimaddress Doc_EmpID Doc_Fname Doc_Lname Doc_Office SymptomDecription App_Status 10am 300330 Tom, White 123-456 2394 Pooz Street, Corvallis, OR, 97330 TW@email.com Moda 12333 PO Box 40168 Portland, OR 97240 1001 Codd Gates 666-888 headache and cough Closed 10am 300231 Stacy Allen 333-456 4857 Quarry Drive, Corvallis, OR, 97330 SA@email.com Moda 23573 PO Box 40168 Portland, OR 97240 1002 Jane Moss 444-333 backpain Pending 8am 300330 Tom, White 123-456 2394 Pooz Street, Corvallis, OR, 97330 TW@email.com Providence 569419 9427 SW Barnes Road, Portland, OR 97225 1001 Codd Gates 666-888 Fatigue Cancelled 2pm 300111 Robert, Pate 123-222 2420 Chandler Drive, Benton OR, 97440 RP@email.com Providence 569419 9427 SW Barnes Road, Portland, OR 97225 1002 Jane Moss 444-333 Fatigue Pending -
- Use normalization techniques you learned in this class to normalize this table. Your answers will be a description of your resulting tables. For each table, give the name of columns, PK and FK (if any) (Note: your relationship should be consistent with the data in the file. For example, patient 1001 uses different insurance plans for different appointment ) (10 points)
Example: Table 1: PatientID (PK), PateintName, PatientPhone, PatientAddress, PatientEmail
- Please explain the advantages and disadvantages (if any) of the normalized tables. (5 points)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database Design Application Development And Administration
Authors: Michael V. Mannino
3rd Edition
0071107010, 978-0071107013
