David Beckham, Alan K. Dippel, Mark Gailey
CSC-671
Fall1998
Professor: Fred Sadri
Department of Mathematical Sciences
University of North Carolina at Greensboro
Hospital Database Tables( Note: ER Diagram attributes should correspond )
Patients:
Patients1 = { SSNo, LastName, FirstName, DOB, Sex, Street, Zip}
Patients2 = { DOB, Age}
Patients3 = { Zip, City, State}
Doctors:
Doctors = { SSNo, LastName, FirstName, Specialty, OfficePhone, Pager}
Examines:
Examines = { Doctors.SSNo, Patients1.SSNo, Date, Time, Diagnosis, Fee}
Accounts:
Accounts = {Patients1.SSNo, DateIn, DateOut, Total}
Beds:
Beds = { Room#, Bed#, PricePerHour, BedType, Status}
Bed_Assignment:
Bed_Assignment = { SSNo, RoomNumber, BedNumber, DateIn, DateOut, TimeIn, TimeOut, Amount}