Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Produce a comprehensive design for a fully functional system which includes interface and output designs, data validations and data normalisation.
Typology: Study notes
1 / 7
This page cannot be seen from the preview
Don't miss anything!
GU-2020-
Simranjit Kaur
GU-2020-
Normalization may be defined as a process which is used to reduce or remove redundancy from relation. It is done by breaking large redundant relation into smaller relation. FULLY FUNCTIONAL SYSTEM Fully functional system occurs when an attribute is functionally dependent on another attribute but not on any subset of that attribute. Hospital management database system has the following entities with their attributes. Employee (Emp_id, Emp_name, Emp_position, Emp_salary) Department (Dep_id, Dep_name, Emp_id) Doctor (Doc_id, Doc_name, Doc_address, Doc_contactno, Doc_specialication, Emp_id) Room (Room_id, Room_type, floorno) Nurse (N_id, N_name, N_address, N_contactno, N_position, Room_id) Patient (Pat_id, Pat_name, Pat_address, Pat_contactno, Pat_diagnosis, Apt_date, Apt_time, Doc_id, Room_id)
Table 2.2: Room Table 2.3: Department Room_i d Dep_i d
- GU-2020- GU-2020- Doc_id Doc_name Doc_address Doc_contactno Doc_specialization Emp_id D101 Dev Sharma Hno.86,street 6,Jalandhar,P unjab 9937518934 Psychiatrist D D102 Anurag Gupta Hno.16,street 1,Jalandhar,P unjab 4559812093 Surgeon D D103 Sonali Handa Hno.26,street 2,Jalandhar,P unjab 8891289334 Cardiologist D D104 Harpreet singh Hno.54,street 4,Jalandhar,P unjab 1893334981 Dentist D D105 Manpreet Singh Hno.84,street 9,Jalandhar,P unjab 5561239876 Cardiologist D Table 2.4: Doctor N_id N_name N_address N_contactno N_position Room_id Emp_id
GU-2020- id name address contactno nosis date ime name id P301 Devika Chadha Hno.102, street 4, Jalandhar, Punjab 9988025678 Psychiatri c disorder
10:30 D101 Dev Sharma
P302 Ritik Gogna Hno.111, street 1, Ludhiana, Punjab 4490126792 Neurosur gery
11:30 D102 Anurag Gupta
P303 Kritik Verma Hno.32, Street 7, Hoshiarpur, Punjab 5634009124 Bradycard ia
12:30 D103 Sonali Handa
P304 Ravneet Kaur Hno.78, Street 7, Amritsar, Punjab 5612309458 Gum disease
10:25 D104 Harpree t singh
P305 Upasna Kaur Hno.88, Street 4, Amritsar, Punjab 5656109456 Heart Surgery
11:30 D102 Anurag Gupta
Table 2.6: Patient