• David Beckham, Alan K. Dippel, Mark Gailey
  CSC-671
  Fall1998
  Professor: Fred Sadri
  Department of Mathematical Sciences
  University of North Carolina at Greensboro

  Hospital Relational Model from E-R Diagram.

• Patients = {SSNo, LastName, FirstName, HomePhone, Sex, DateofBirth, Age, Street, City, State, Zip}

Relational Dependencies = {SSNo à LastName, FirstName, HomePhone, Sex, DateofBirth, Street, City, State, Zip; Zip à City, State; DateofBirth à Age}

• Doctors = {SSNo, LastName, FirstName, OfficePhone, Pager, Specialty}

  Doctors Relational Dependencies = {SSNo à LastName, FirstName,OfficePhone, Specialty}

• Examines = {PSSNo, DSSNo, Date, Time, Diagnosis, Fee}

  Examines Relational Dependencies = {

  , relational set with attributes Date, Time, Diagnosis, Fee.

• Beds = {RoomNumber, BedNumber, Type, Status, PricePerHour}

Beds Relational Dependencies = {

• Bed_Assigned = {PSSNo, RoomNumber, BedNumber, DateIn, TimeIn, DateOut, TimeOut, Amount}

Bed_Assigned Relational Dependencies = {RoomNumber, BedNumber, DateIn, TimeIn, DateOut, Time.Out à Amount},

• Accounts = {SSNo, DateIn, DateOut, Amount}

Accounts Relational Dependencies = {