Database Design

Reply

Join Date: Nov 2007
Posts: 9
Reputation: chetah is an unknown quantity at this point 
Solved Threads: 0
chetah chetah is offline Offline
Newbie Poster

Database Design

 
0
  #1
Nov 21st, 2007
Question Details:
Help Needed

Hospital Associates own three private hospitals at different locations across the country. It has a centralize database for tracking patients admission and billing. The database schema contains the following tables:
PATIENTS(PatientId, Name, Address,DateofBirth,AccBalance)
ADMISSION(AdmissionId, PatientId(FK), RoomId(FK), AdmitDate, DischargeDate)
ADMITDETAILS(AdmissionId, TreatmentId(FK), DoctorId(FK))
ROOM (RoomId, HospitalId(FK), RoomType, CostPerNight)
TREAMENT(TreatmentId, Prescription, Cost)
DOCTORS(DoctorId, DoctorName)
HOSPITAL(HospitalId, HospitalName)
Draw a ER diagram for the database schema given above. Explain how you arrive at the maximum and minimum values for the relation ship between Admission and Rooms in your ERD.
Reply With Quote Quick reply to this message  
Join Date: Apr 2005
Posts: 16,148
Reputation: jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all 
Solved Threads: 531
Moderator
Featured Poster
jbennet's Avatar
jbennet jbennet is offline Offline
Moderator

Re: Database Design

 
0
  #2
Nov 22nd, 2007
thats easy

An er diagram shows the data and the relations using "crows feet" for one to many etc....
If i am helpful, please give me reputation points.
Reply With Quote Quick reply to this message  
Join Date: Apr 2009
Posts: 1
Reputation: speciality is an unknown quantity at this point 
Solved Threads: 0
speciality speciality is offline Offline
Newbie Poster

Re: Database Design

 
0
  #3
Apr 2nd, 2009
Can anyone tell me where these questions are coming from.What book and the author
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC