We would like to design a database to maintain information about hospi

1.	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» 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

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»

the columns should be for staff:

1. id

2. role

3. name

4. contact

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