Question

We would like to design a database to maintain information about hospital staff, including doctors, nurses and patients at the hospital. The information we need includes:

Answer 1

the columns should be for staff:

1. id

2. role

3. name

4. contact

5. address

6. working or stay area

in case of patient some other columns may be include:

1. name

2. date of admit

3.date of discharge

4. room no.

5. bill amount

6. ward

7. address