Question: Draw the Relational Database Schema Diagram, then show the Functional Dependency an'd Referential Integrity for the following Hospital Invoice Database: ACCOUNT ( InvoiceNbr , AccountNbr,
Draw the Relational Database Schema Diagram, then show the Functional Dependency an'd Referential Integrity for the following Hospital Invoice Database:
ACCOUNT InvoiceNbr AccountNbr, InvoiceDate, DueDate, DateAdmitted, DateDischarged PATIENT PatientNbr PatientName, PatientAddress, City, State, Zip
PATIENTCHARGES InvoiceNbr ItemCode, Charge
ITEM ItemCode Description
ADMISION PatientNbr DateAdmitted, DateDischarged, Location
ROOM Location Accommodation, Extension
OCCUPANCY Location DateAdmitted, PatientNbr
PROCEDURELOCATION PatientNbr Proceduredate, Location
ACCOUNTPTIENT AccountNbr PatientNbr
Note: The Relational Schema above is in Normal Form relations with the Functional Dependencies and Referential Integrity constraints.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
