Hello Please help Creating ERD DIAGRAM of the following problem

Discussion in 'Databases' started by sherwina, Jul 17, 2012.

  1. #1
    Please help me in the following
    I couldn't answer this as my teacher taught us only unary

    We would like to design a database to maintain information about
    hospital staffs, including doctors and nurses, and patients at the hospital.
    The information we need includes:
    • Staff, including their names, addresses and social-security
    numbers.
    • Patients, including their names, addresses, and the name of
    their insurance company.
    • Patients are each assigned to a ward (room).
    • Those staffs who are nurses are assigned to zero or more
    wards. Each ward has at least one nurse assigned.
    • Those staffs who are doctors are assigned to zero or more
    patients. Patients may or may not have a doctor assigned, and
    they may have more than one doctor. Patients in the same ward
    may have different doctors but will always have the same
    nurse(s).
    Specify an entity-relationship diagram for this database. Don't forget
    to underline key attributes and include arrowheads indicating the
    multiplicity of relationships.

    I need help on this. I will post my work based on my analysis here in 1 hour
     
    sherwina, Jul 17, 2012 IP