Question: please post picture the table from excel INSY 3304 - Project 1 Appt ID Appt Date Appt | Block Block Time Code Desc Reason Code

 please post picture the table from excel INSY 3304 - Project

please post picture the table from excel

INSY 3304 - Project 1 Appt ID Appt Date Appt | Block Block Time Code Desc Reason Code Reason Desc Patient ID Patient Name Patient Phone Billing Type Billing Type Desc Ins Co ID Ins Co Name Dr ID Dr Name Appt Status Code Appt Status Desc Emt Status Pmt Desc Block Minutes 10 Minutes 9.00 101 9/25/2021 L1 Level 1 NP 101 Wesley Tanner (817)555- 1193 1 Insurance 323 Humana 2 Michael Smith CM Complete PF Paid in Full AM New Patient General Back Pain L2 Level 2 15 Minutes GBP L2 Level 2 15 Minutes XR X-Ray 102 9/25/2021 9:00 AM L1 Level 1 1 10 Minutes PSF 100 Brenda Rhodes (214)555- 9191 1 Insurance 129 Blue Cross 5 Janice May CM Complete PP Partial Pmt L1 Level 1 1 10 Minutes SR Michael 103 9/25/2021 10:00 AM L1 Leve 1 1 10 Minutes PSF 15 Jeff Miner (469)555 2301 SP Self-Pay - 2 CM PF Complete Smith Paid in Full L2 SR 10:30 104 9/25/2021 L3 PT 77 WC Worker's Comp 210 State Farm 1 CM Complete PF AM 10:30 AM Kim Jackson Mary Vaughn 15 Minutes 20 Minutes 10 Minutes 15 Minutes 30 (817)555 4911 (817)555- 2334 Kay Jones Michas Smith 105 9/25/2021 Paid in Full Partial Pm Li NP 119 1 Insurance 129 Blue Cross 2 CM Complete Level 2 Level 3 3 Level 1 Level 2 Level 4 Level 3 PP L2 AI Post- Surgery Follow Up Suture Removal Post- Surgery Follow Up Suture Removal Physical Therapy New Patient Auto Injury Physical Therapy Physical Therapy General Back Pain Post- Surgery Follow Up Suture Removal Physical Therapy New Patient 106 9/25/2021 L4 PT 97 SP Self-Pay - 3 Complete NP Minutes 10:30 AM 11:30 AM Chris Mancha Renee Walker (469)555- 3440 (214)555- 9285 Ray Schultz Ray Schultz Not Paid Partial Pmt 107 9/25/2021 13 20 Minutes PT 28 1 Insurance 129 Blue Cross 3 CN Confirmed PP 108 9/25/2021 11:30 AM L2 Level 2 15 Minutes GBP 105 Johnny Redmond (214)555- 1084 1 Insurance 323 Humana 2 Michael Smith CN Confirmed NP Not Paid 109 9/25/2021 Not 2.00 PM L1 Level 1 10 Minutes PSF 84 James Clayton (214)555- ) 9285 1 Insurance 135 TriCars 5 Janice May CN Confirmed NP Paid L2 SR 110 9/26/2021 14 PT 84 1 Insurance 135 Tricare 3 NC 8:30 AM 8:30 AM Not Confirmed NP James Clayton Shelby Davis Level 2 2 Level 4 Level 1 Level 2 2 Level 2 2 (214)555 9285 (817)555 1198 15 Minutes 30 Minutes 10 Minutes 15 Minutes 15 Minutes Ray Schultz Janice May 111 Not Paid Not Paid 9/26/2021 LI NP 23 WC Worker's Comp 323 Humana 1 CN Confirmed NP L2 HP Hip Pain L2 XR X-Ray Additional Information: Each patient has at least one appointment. Each appointment is for a specific patient. Each appointment is handled by a specific doctor. Each doctor may handle one or more appointments (or may have no appointments). Each appointment has one or more block codes and one or more reason codes. Each appointment has one billing type. Billing type may be assigned to one or more appointments (or to no appointments). Each appointment has a specific status code applied. There may be status codes which have not been applied to any appointments. Based on the information provided above, complete the following: 1. FIRST NORMAL FORM (1NF): a. Decompose the composite attributes into simple attributes. b. Convert the table above to 1NF (eliminate repeating groups of data and select an appropriate PK). Show the table structure format (table name with PK and all dependent attributes in parentheses). d. Create a dependency diagram for the table above. c

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!