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.

EBK HEALTH ECONOMICS AND POLICY
7th Edition
ISBN:9781337668279
Author:Henderson
Publisher:Henderson
Chapter12: Medicare
Section: Chapter Questions
Problem 5QAP
Question
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.
Transcribed Image Text: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.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK HEALTH ECONOMICS AND POLICY
EBK HEALTH ECONOMICS AND POLICY
Economics
ISBN:
9781337668279
Author:
Henderson
Publisher:
YUZU
Principles of Economics 2e
Principles of Economics 2e
Economics
ISBN:
9781947172364
Author:
Steven A. Greenlaw; David Shapiro
Publisher:
OpenStax