Room Patient Test_Report

0..1 0..1
R_ID int P_ID int Report_ID int
*
Type varchar(50) Name varchar(100) P_ID int

Capacity int DOB date Test_Type varchar(100)

Availability varchar(50) Gender varchar(10) Result varchar(255)

Mob_No varchar(15)

Age int
Employee Bill
*
1 R_ID int
E_ID int B_ID int
*
Name varchar(100) P_ID int

Salary decimal(10,2) Doctor Amount decimal(10,2)

*
0..1
Sex varchar(10) E_ID int Bill_Date date

Mob_No varchar(15) Department varchar(100)

Address varchar(255) Qualification varchar(100)

Patient_Doctor
State varchar(50) *
P_ID int
City varchar(50) *
Nurse E_ID int
Pin_No varchar(10) *
0..1
E_ID int primary key(P_ID,E_ID)

Records
Nurse_Room
0..1
Record_No int Receptionist *
* E_ID int
App_No int 0..1
E_ID int *
R_ID int

primary key(E_ID,R_ID)

Receptionist_Records
*
E_ID int
*
Record_No int

primary key(E_ID,Record_No)
Room Patient Test_Report
0..1 0..1
R_ID int P_ID int Report_ID int
*
Type varchar(50) Name varchar(100) P_ID int

Capacity int DOB date Test_Type varchar(100)

Availability varchar(50) Gender varchar(10) Result varchar(255)

Mob_No varchar(15)

Age int
Employee Bill
*
1 R_ID int
E_ID int B_ID int
*
Name varchar(100) P_ID int

Salary decimal(10,2) Doctor Amount decimal(10,2)

*
0..1
Sex varchar(10) E_ID int Bill_Date date

Mob_No varchar(15) Department varchar(100)

Address varchar(255) Qualification varchar(100)

Patient_Doctor
State varchar(50) *
P_ID int
City varchar(50) *
Nurse E_ID int
Pin_No varchar(10) *
0..1
E_ID int primary key(P_ID,E_ID)

Records
Nurse_Room
0..1
Record_No int Receptionist *
* E_ID int
App_No int 0..1
E_ID int *
R_ID int

primary key(E_ID,R_ID)

Receptionist_Records
*
E_ID int
*
Record_No int

primary key(E_ID,Record_No)