INSY 3304 - Project 1 Billing Ins Appt Appt Appt Appt Date Appt Block Block Time Code Desc Block Minutes Reason Code Reason Patient Desc ID Patient Name Patient Billing Phone Type Ins Co Dr Dr Type Desc Co Status Status Prot Pmt Name ID Name Status Desc ID Code Desc 9:00 Level 101 9/25/2021 L1 AM 1 10 Minutes NP New Patient 101 Wesley Tanner (817)555- 1193 Michael 1 Insurance 323 Humana 2 см Complete PF Smith Paid: in Full General Level 12 2 15 Minutes GBP Back Pain Level 15 L2 XR 2 Minutes X-Ray 9:00 Level 10 Post- Surgery Brenda 102 9/25/2021 L1 PSF 100 AM 1 Minutes Follow Rhodes (214)555- 9191 1 Insurance 129 Blue Cross 5 Janice May CM Complete PP Partial Pont Up Level L1 1 10 Minutes Suture SR Removal Post- 10:00 Level 10 Surgery Jeff 103 9/25/2021 L1 PSF 15 AM 1 Minutes Follow Miner (469)555- 2301 SP Self-Pay 2 Michael Smith CM Complete PF Paid in Full Up Level 15 Suture L2 SR 2 Minutes Removal 10:30 Level 20 Physical Kim 104 9/25/2021 L3 PT 77 AM 3 Minutes Therapy Jackson 10:30 Level 105 9/25/2021 L1 AM 1 10 Minutes New Mary NP 119 Patient Vaughn (817)555- 4911 (817)555- 2334 WC Worker's Comp State Kay 210 1 Farm Jones Blue Michael Insurance 129 2 Cross Smith Level 15 Auto L2 Al 2 Minutes Injury 10:30 Level 30 Physical Chris 106 9/25/2021 14 PT 97 AM 4 Minutes Therapy Mancha 11:30 Level 20 Physical 107 9/25/2021 L3 PT 28 AM 3 Minutes Therapy Renee Walker (469)555- 3440 (214)555- 9285 Ray SP Self-Pay 3 Schultz Blue Ray 1 Insurance 129 3 Cross Schultz General 11:30 Level 15 Johnny 108 9/25/2021 L2 GBP Back 105 AM 2 Minutes Redmond (214)555- 1084 1 Insurance 323 Humana 2 Michael Smith ཅ་ཅོ། ཎ ན། ན Complete PF Paid in Full Partial Complete PP Pmt Not Complete NP Paid: Partial Confirmed PP Pmt Not Confirmed NP Paid Pain Post- 2:00 Level 109 9/25/2021 L1 PM 1 10 Minutes Surgery PSF 84 Follow James Clayton (214)555- 9285 1 Insurance 135 TriCare 5 Janice May Not CN Confirmed NP Paid Up L2 8:30 Level 2 Level 15 Minutes Suture SR Removal 30 Physical James 110 9/26/2021 14 PT 84 AM 8:30 4 Level Minutes Therapy Clayton 10 New 111 9/26/2021 LI NP 23 AM 1 Minutes Patient Shelby Davis (214)555- 9285 (817)555- 1198 1 WC Insurance 135 TriCare Worker's Comp 323 Humana ☐ ☐ 23 Ray NC Schultz Janice May Not Confirmed Not NP Paid Not CN Confirmed NP Paid Level 12 2 15 Minutes HP Hip Pain L2 Level 2 15 Minutes 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). c. Show the table structure format (table name with PK and all dependent attributes in parentheses). d. Create a dependency diagram for the table above.
INSY 3304 - Project 1 Billing Ins Appt Appt Appt Appt Date Appt Block Block Time Code Desc Block Minutes Reason Code Reason Patient Desc ID Patient Name Patient Billing Phone Type Ins Co Dr Dr Type Desc Co Status Status Prot Pmt Name ID Name Status Desc ID Code Desc 9:00 Level 101 9/25/2021 L1 AM 1 10 Minutes NP New Patient 101 Wesley Tanner (817)555- 1193 Michael 1 Insurance 323 Humana 2 см Complete PF Smith Paid: in Full General Level 12 2 15 Minutes GBP Back Pain Level 15 L2 XR 2 Minutes X-Ray 9:00 Level 10 Post- Surgery Brenda 102 9/25/2021 L1 PSF 100 AM 1 Minutes Follow Rhodes (214)555- 9191 1 Insurance 129 Blue Cross 5 Janice May CM Complete PP Partial Pont Up Level L1 1 10 Minutes Suture SR Removal Post- 10:00 Level 10 Surgery Jeff 103 9/25/2021 L1 PSF 15 AM 1 Minutes Follow Miner (469)555- 2301 SP Self-Pay 2 Michael Smith CM Complete PF Paid in Full Up Level 15 Suture L2 SR 2 Minutes Removal 10:30 Level 20 Physical Kim 104 9/25/2021 L3 PT 77 AM 3 Minutes Therapy Jackson 10:30 Level 105 9/25/2021 L1 AM 1 10 Minutes New Mary NP 119 Patient Vaughn (817)555- 4911 (817)555- 2334 WC Worker's Comp State Kay 210 1 Farm Jones Blue Michael Insurance 129 2 Cross Smith Level 15 Auto L2 Al 2 Minutes Injury 10:30 Level 30 Physical Chris 106 9/25/2021 14 PT 97 AM 4 Minutes Therapy Mancha 11:30 Level 20 Physical 107 9/25/2021 L3 PT 28 AM 3 Minutes Therapy Renee Walker (469)555- 3440 (214)555- 9285 Ray SP Self-Pay 3 Schultz Blue Ray 1 Insurance 129 3 Cross Schultz General 11:30 Level 15 Johnny 108 9/25/2021 L2 GBP Back 105 AM 2 Minutes Redmond (214)555- 1084 1 Insurance 323 Humana 2 Michael Smith ཅ་ཅོ། ཎ ན། ན Complete PF Paid in Full Partial Complete PP Pmt Not Complete NP Paid: Partial Confirmed PP Pmt Not Confirmed NP Paid Pain Post- 2:00 Level 109 9/25/2021 L1 PM 1 10 Minutes Surgery PSF 84 Follow James Clayton (214)555- 9285 1 Insurance 135 TriCare 5 Janice May Not CN Confirmed NP Paid Up L2 8:30 Level 2 Level 15 Minutes Suture SR Removal 30 Physical James 110 9/26/2021 14 PT 84 AM 8:30 4 Level Minutes Therapy Clayton 10 New 111 9/26/2021 LI NP 23 AM 1 Minutes Patient Shelby Davis (214)555- 9285 (817)555- 1198 1 WC Insurance 135 TriCare Worker's Comp 323 Humana ☐ ☐ 23 Ray NC Schultz Janice May Not Confirmed Not NP Paid Not CN Confirmed NP Paid Level 12 2 15 Minutes HP Hip Pain L2 Level 2 15 Minutes 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). c. Show the table structure format (table name with PK and all dependent attributes in parentheses). d. Create a dependency diagram for the table above.
Chapter12: Medicare
Section: Chapter Questions
Problem 5QAP
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Principles of Economics 2e
Economics
ISBN:
9781947172364
Author:
Steven A. Greenlaw; David Shapiro
Publisher:
OpenStax
Principles of Economics 2e
Economics
ISBN:
9781947172364
Author:
Steven A. Greenlaw; David Shapiro
Publisher:
OpenStax