New Century Health Clinic

New Century Health Clinic offers preventive medicine and traditional medical care. In your role as an IT consultant, you will help New Century develop a new information system.
Background
After completing the user interface, input, and output design for the new information system at New Century, you will consider data design issues. Begin by studying the DFDs and object-oriented diagrams you prepared previously and the rest of the documentation from the systems analysis phase. Perform the following tasks: Assignments
1. Create an initial entity-relationship diagram for the New Century Health Clinic system.


2. Normalize your table designs


PATIENT (PATIENT_NUMBER, PATIENT FIRST NAME, PATIENT LAST NAME, DATE OF BIRTH, HOUSEHOLD NUMBER, RELATIONSHIP CODE) 

APPOINTMENT (APPT NUMBER, PATIENT NUMBER, APPOINTMENT DATE, APPOINTMENT TIME, PROVIDER NUMBER)

APPT_SERVICE (APPT_SERVICE_NUMBER, APPT NUMBER, CPT CODE, STATUS,FEE, EXPLANATION)



PROVIDER (PROVIDER_NUMBER, PROVIDER NAME)



 EMPLOYER (EMPLOYER_NUMBER, EMPLOYERNAME, INSURANCEGROUPNUMBER)



 HOUSEHOLD (HOUSEHOLDNUMBER, HOUSEHOLD LASTNAME, HOUSEHOLDFIRSTNAME, HOUSEHOLDADDRESS, HOUSEHOLDCITY, HOUSEHOLDSTATE, HOUSEHOLDZIPCODE, EMPLOYERNUMBER, HOUSEHOLDHOME PHONE, HOUSEHOLDWORK PHONE, PRIOR BALANCE, CHARGESYTD, HOUSEHOLDPAYMENTSYTD, INSURANCEPAYMENTSYTD) 



INSURANCE CO (INSURANCECOMPANYNUMBER, INSURANCECOMPANY ADDRESS, INSURANCECOMPANYCITY, INSURANCECOMPANYSTATE, INSURANCECOMPANYZIPCODE, INSURANCECOMPANYPHONE)



CPT_CODE_FEE (CPTCODE, CPTDESCRIPTION, STANDARDFEE)



CLAIMS (CLAIMNUMBER, INSURANCE COMPANYNUMBER, APPTSERVICENUMBER, CLAIMAMOUNT, CLAIMDATE)



 CHARGES (CHARGENUMBER, APPT_SERVICE, PATIENT_NUMBER, CHARGE _DATE, FEE)



 MTD PAYMENTS (PAYMENT_NUMBER, HOUSEHOLDNUMBER, PAYMENTDATE,PAYMENTAMOUNT, PAYMENTSOURCE, INSURANCE COMPANYNUMBER)








Mga Komento

Mga sikat na post sa blog na ito

4 Western Wear Outfitters

3 Mayville Public Library