Scribd
Upload
13 views2 pages

Mapping Task

Uploaded by

ramiwael476
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
13 views2 pages

Mapping Task

Uploaded by

ramiwael476
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Nurse Patient Examine

0..1 1 *
nurse_id int patient_id int consultant_id int
Ward
*
F_name varchar 0..1 F_name varchar patient_id int
ward_id int
L_name varchar L_name varchar
name varchar
phone_number varchar * date_of_birth date
consultant_id int PatientDrug
street varchar age int *
patient_id int
*
city varchar ward_id int *
drug_code int
*
ward_id int nurse_id int
admin_time datetime

Consultant
0..1
consultant_id int 1

name varchar

Drug
1
drug_code int

brand varchar

dosage varchar
Nurse Patient Examine
0..1 1 *
nurse_id int patient_id int consultant_id int
Ward
*
F_name varchar 0..1 F_name varchar patient_id int
ward_id int
L_name varchar L_name varchar
name varchar
phone_number varchar * date_of_birth date
consultant_id int PatientDrug
street varchar age int *
patient_id int
*
city varchar ward_id int *
drug_code int
*
ward_id int nurse_id int
admin_time datetime

Consultant
0..1
consultant_id int 1

name varchar

Drug
1
drug_code int

brand varchar

dosage varchar

You might also like