Database Design

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 427,187 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,197 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Database Design advertiser: Programming Forums

Thread Tools Display Modes

Views: 875 | Replies: 1

•

Join Date: Nov 2007

Posts: 9

Reputation: chetah is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

chetah

Offline

Newbie Poster

Database Design

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.