PATIENT ID #(PK) NAME ADMIT DATE DISCHARGE DATE AGE SEX RESOURCES ADDRESS ADMINSTRATIVE ASST. ID #(PK) MEDICAL RECORDS APPOINTMENTS CASE Mgr/Social Wkr. ID (PK) EDUCATION LICENSE 123456789 JANE DOE 6/9/2024 6/12/2024 45 FEMALE CHILDREN 888 MACKY LN. HOSP. 626262(FK) PATIENT ID# DATE HOSP. 626262(FK) MSW 848485 PAYMENT MRN (PK) 123456789 INSURANCE BCBS N 999 888 SELF PAY MEDICARE MEDICAID DOCTOR HOSP. 626262(FK) FULL PRIV. YES ID #(PK) AFFILIATION PRIVILEGES SPECIALTY NPI LICENSE SURGICAL SERVICES 75757575 23456 TREATMENT ID (PK) PROCEDURE CODE ICD CODE ID #(PK) EDUCATION LICENSE SPECIALTY ID #(PK) SERVICES TELEHEALTH INPATEINT OUTPATIENT NURSE MEDICAL DX HOSP. 626262(FK) BSN 12456 MED SURG HOSPITAL 626262(FK) INPTIOPT YES YES CLINICS(SURG/MED) TRANSPORTATION ID #(PK) RESOURCES PRIVATE AUTO LOCATION HOSP. 626262(FK) FAMILY FUNDS YES PHYSICAL ADDRESS
PATIENT ID #(PK) NAME ADMIT DATE DISCHARGE DATE AGE SEX RESOURCES ADDRESS ADMINSTRATIVE ASST. ID #(PK) MEDICAL RECORDS APPOINTMENTS CASE Mgr/Social Wkr. ID (PK) EDUCATION LICENSE 123456789 JANE DOE 6/9/2024 6/12/2024 45 FEMALE CHILDREN 888 MACKY LN. HOSP. 626262(FK) PATIENT ID# DATE HOSP. 626262(FK) MSW 848485 PAYMENT MRN (PK) 123456789 INSURANCE BCBS N 999 888 SELF PAY MEDICARE MEDICAID DOCTOR HOSP. 626262(FK) FULL PRIV. YES ID #(PK) AFFILIATION PRIVILEGES SPECIALTY NPI LICENSE SURGICAL SERVICES 75757575 23456 TREATMENT ID (PK) PROCEDURE CODE ICD CODE ID #(PK) EDUCATION LICENSE SPECIALTY ID #(PK) SERVICES TELEHEALTH INPATEINT OUTPATIENT NURSE MEDICAL DX HOSP. 626262(FK) BSN 12456 MED SURG HOSPITAL 626262(FK) INPTIOPT YES YES CLINICS(SURG/MED) TRANSPORTATION ID #(PK) RESOURCES PRIVATE AUTO LOCATION HOSP. 626262(FK) FAMILY FUNDS YES PHYSICAL ADDRESS
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
Related questions
Question
How do i test this database? What are the total number of rows will i need?
I need answer typing clear urjent no chatgpt used i will give upvotes
![PATIENT
ID #(PK)
NAME
ADMIT DATE
DISCHARGE DATE
AGE
SEX
RESOURCES
ADDRESS
ADMINSTRATIVE ASST.
ID #(PK)
MEDICAL RECORDS
APPOINTMENTS
CASE Mgr/Social Wkr.
ID (PK)
EDUCATION
LICENSE
123456789
JANE DOE
6/9/2024
6/12/2024
45
FEMALE
CHILDREN
888 MACKY LN.
HOSP. 626262(FK)
PATIENT ID#
DATE
HOSP. 626262(FK)
MSW
848485
PAYMENT
MRN (PK)
123456789
INSURANCE
BCBS
N
999
888
SELF PAY
MEDICARE
MEDICAID
DOCTOR
HOSP. 626262(FK)
FULL PRIV.
YES
ID #(PK)
AFFILIATION
PRIVILEGES
SPECIALTY
NPI
LICENSE
SURGICAL SERVICES
75757575
23456
TREATMENT
ID (PK)
PROCEDURE CODE
ICD CODE
ID #(PK)
EDUCATION
LICENSE
SPECIALTY
ID #(PK)
SERVICES
TELEHEALTH
INPATEINT
OUTPATIENT
NURSE
MEDICAL DX
HOSP. 626262(FK)
BSN
12456
MED SURG
HOSPITAL
626262(FK)
INPTIOPT
YES
YES
CLINICS(SURG/MED)
TRANSPORTATION
ID #(PK)
RESOURCES
PRIVATE AUTO
LOCATION
HOSP. 626262(FK)
FAMILY FUNDS
YES
PHYSICAL ADDRESS](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F18bcbb5d-9ba3-41d1-904c-b6a73ba25db9%2F0e0db62c-6fac-4e39-bacc-e5435c914268%2Fibl7b5_processed.jpeg&w=3840&q=75)
Transcribed Image Text:PATIENT
ID #(PK)
NAME
ADMIT DATE
DISCHARGE DATE
AGE
SEX
RESOURCES
ADDRESS
ADMINSTRATIVE ASST.
ID #(PK)
MEDICAL RECORDS
APPOINTMENTS
CASE Mgr/Social Wkr.
ID (PK)
EDUCATION
LICENSE
123456789
JANE DOE
6/9/2024
6/12/2024
45
FEMALE
CHILDREN
888 MACKY LN.
HOSP. 626262(FK)
PATIENT ID#
DATE
HOSP. 626262(FK)
MSW
848485
PAYMENT
MRN (PK)
123456789
INSURANCE
BCBS
N
999
888
SELF PAY
MEDICARE
MEDICAID
DOCTOR
HOSP. 626262(FK)
FULL PRIV.
YES
ID #(PK)
AFFILIATION
PRIVILEGES
SPECIALTY
NPI
LICENSE
SURGICAL SERVICES
75757575
23456
TREATMENT
ID (PK)
PROCEDURE CODE
ICD CODE
ID #(PK)
EDUCATION
LICENSE
SPECIALTY
ID #(PK)
SERVICES
TELEHEALTH
INPATEINT
OUTPATIENT
NURSE
MEDICAL DX
HOSP. 626262(FK)
BSN
12456
MED SURG
HOSPITAL
626262(FK)
INPTIOPT
YES
YES
CLINICS(SURG/MED)
TRANSPORTATION
ID #(PK)
RESOURCES
PRIVATE AUTO
LOCATION
HOSP. 626262(FK)
FAMILY FUNDS
YES
PHYSICAL ADDRESS
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Understanding Business](https://www.bartleby.com/isbn_cover_images/9781259929434/9781259929434_smallCoverImage.gif)
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
![Management (14th Edition)](https://www.bartleby.com/isbn_cover_images/9780134527604/9780134527604_smallCoverImage.gif)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
![Spreadsheet Modeling & Decision Analysis: A Pract…](https://www.bartleby.com/isbn_cover_images/9781305947412/9781305947412_smallCoverImage.gif)
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
![Understanding Business](https://www.bartleby.com/isbn_cover_images/9781259929434/9781259929434_smallCoverImage.gif)
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
![Management (14th Edition)](https://www.bartleby.com/isbn_cover_images/9780134527604/9780134527604_smallCoverImage.gif)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
![Spreadsheet Modeling & Decision Analysis: A Pract…](https://www.bartleby.com/isbn_cover_images/9781305947412/9781305947412_smallCoverImage.gif)
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
![Management Information Systems: Managing The Digi…](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9780135191798/9780135191798_smallCoverImage.jpg)
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
![Business Essentials (12th Edition) (What's New in…](https://www.bartleby.com/isbn_cover_images/9780134728391/9780134728391_smallCoverImage.gif)
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
![Fundamentals of Management (10th Edition)](https://www.bartleby.com/isbn_cover_images/9780134237473/9780134237473_smallCoverImage.gif)
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON