Attributes

Bus (reg-no,make,size,deck,no-pass)
Route (route-no,avg-pass)
Driver (emp-no,name,address,tel-no)
Town (name)
Stage (stage-no)
Garage (name,address)
Example: Entity and Relationship sets for the hospital called General Hospital,
Patients,
Doctors, Beds, Examines, Bed Assigned, Accounts, has Account.
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

0 comments