Hi everyone,
I need some help with identifying real world entities and their attributes for a hospital scenario. I have listed below the entities and attributes that I could think of. Please comment or give suggestions on how I can improve it.
EMPLOYEE ([U][B]Employee_SSN[/B][/U], Address_ID, Contact_ID, Employee_Name, Designation, Salary)
PATIENT ([U][B]Patient_SSN[/B][/U], Address ID, Contact_ID Patient_Name, Disease)
MEDICAL_HISTORY ([U][B]Patient_SSN[/B][/U], Treatment_ID, History)
CONTACT ([U][B]Contact ID[/B][/U], Email, TelNo)
ADDRESS ([U][B]Address ID[/B][/U], Street, City, State, Zip and Region)
DOCTOR ([U][B]Doc_ID[/B][/U], Doc_Name, Department)
PRESCRIPTION ([U][B]Prescription_ID[/B][/U], Patient_SSN, Medication_Name, Prescription_Type, Frequency, Instruction, Expiry_Date, Stock)
WARD ([U][B]Ward ID[/B][/U], Ward_Name, Main_Treatment, Nurse_In_Charge, Number_Of_Bed)
TREATMENT ([U][B]Treatment_ID[/B][/U], Treatment_Type, Treatment_Date, Treatment_Location, Fee, Result)
PHARMACY ([U][B]Pharmacy_ID[/B][/U], Pharmacy_Name, Pharmacy_Location, Pharmacy_TelNo)
PATIENT_ADMISSION ([U][B]Patient_SSN[/B][/U], Ward_ID, Admission_Date, Discharge_Date, Admission_Reason, Employee_SSN)
I need to also identify a multi-valued attribute, a weak entity, recursive relationship, Super/ subtype entities, a ternary relationship, relationship with cardinality ratio 1:1, 1:M, N:M.
So far I have only identified a multi-valued attribute which is Pharmacy_TelNo in PHARMACY, a weak entity which is MEDICAL_HISTORY and a recursive relationship which is Nurse_In_Charge in EMPLOYEE. As for the other I have not identified them yet.
Please have a look and tell me if what I have done so far is correct.
Thank you so much
Regards.