David Beckham,
Alan K. Dippel, Mark Gailey
CSC-671
Fall1998
Professor: Fred Sadri
Department of Mathematical Sciences
University of North Carolina at Greensboro
Entity and Relationship sets for the hospital called General Hospital.
Database Project "Hospital"
Patients, Doctors, Beds, Examines, BedAssigned, Accounts, HasAccount.
- patients, entity set with attributes SSNo, LastName, FirstName, HomePhone, Sex,
DateofBirth, Age, Street, City, State, Zip.
- doctors, entity set with attributes SSNo, LastName, FirstName, OfficePhone,
Pager, Specialty.
- examines, relational set with attributes Date, Time, Diagnosis, Fee.
- beds, entity set with attributes RoomNumber, BedNumber, Type, Status,
PricePerHour.
- Bed_assigned, relational set with attributes DateIn, TimeIn, DateOut, TimeOut, Amount.
- accounts, weak entity set with attributes DateIn, DateOut, Amount.
- has_account, relational set with no Attributes

Database Project "Hospital"