how can u help me in my database assignment?

Question

my proffessor asked us to find a database relationship diagram of a hospital. it should explain the entities, and the kind of relationships between them within the hospital starting from a doctor and a nurse, to a surgeon and a patient. so im soo tired of searching and would like to gte some help... help me pleeeeeeeez.

Answer 1

Patient table

Visits table

Patient and Visits have a one to many relationship - One patient can have multiple visits. The patient table will have a patient id as the primary key and the Visits table will use the patient id as a foreign key. Hope this helps.

Answer 2

You need an entity, such as Hospital Employee. Each professional will have an identifier. This could be anything and totally arbitrary, but it must end up being unique for each one. For example, each new Health Professional could have an Employee Number. Each employee should have a type, (ie. GP, RN, LPN, Surgeon). You also need an Attribute, say ROLE, for each Health Professional like GP, RN, LPN, Thoracic Surgeon, etc. You also need an entity for Patient. Each patient must have a patient ID. Maybe SSN. Maybe the patient should have a payer type (ie. Self, Insurance, etc.) You need one for Room. You will also need associative entities which match the patient to the room, so you build an entity such as Patient-room. For that to work, you need a number for the room and a number for the patient. Then, for each patient, there can be only one room, creating a One-to-Many relationship based on the foreign keys of patient number and room number (there can be more than one patient in a room, but you will also want, in the ROOM table, a ROOM TYPE such as Private, Double Occupancy, Quad, ICU, and so on.


Does this help. I really don't think you have to work so much harder on this now.

Answer 3

Too tired ? and expect someone else to do the footwork for you ?

Answer 4

im me i take a loot at your project .. Sure maryburnsart