Download Hospital Management Database: Designing a Relational Database System and more Study Guides, Projects, Research Database Management Systems (DBMS) in PDF only on Docsity!
GU-2020-
DATABASE (HND103)
HND COMPUTING
Assignment 1
Title: Relational Database System
LO1: Use an appropriate design tool to design a relational database system for a
substantial problem.
Submitted To:
Mrs. Gurgeet kaur Assistant Professor Faculty of Computational Science
Submitted By:
Simranjit Kaur
GNA UNIVERSITY, SRI HARGOBINDGARH
PHAGWARA (PUNJAB)
GU-2020-
Acknowledgement
I want to thank many people who have helped me in completing this assignment. Without their proper guidance and encouragement, I would not have made headway in this assignment. First and foremost, I would like to thanks to Mrs. Gurgeet Kaur, Assistant professor of our university, to share her knowledge with me on this assignment. She helped me to understand about all the concepts and her instructions have served as the major contribution towards the completion of the assignment. Secondly, a big thank you to my parents for all what they did and still doing to help me be at this position. Besides, big thanks to all my friends and classmates who have shared their support and improve the quality of my assignment.
GU-2020-
Question 1: Design a relational database system using appropriate design tools
and techniques, containing at least four interrelated tables, with clear statements
of user and system requirements
Answer: Entity Relationship Model
Entity-Relationship is a high level data model which is used to define data elements and relationship between data elements for a specified database system. 1.1: Entity-Relationship Model of Hospital Management Database System
GU-2020-
Question 2: Produce a Comprehensive design for a fully functional system
which includes interface and output designs, data validations and data
normalization.
Answer: NORMALIZATION
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)
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
GU-2020- N_id N_name N_address N_contactno N_position Room_id Emp_id N106 Anureet Kaur Hno.14,street 1,Jalandhar,Pu njab 1289456784 Staff Nurse R401 N N107 Srishti Verma Hno.94,street 5,Jalandhar,Pu njab 1289456791 OT Nurse R409 N N108 Deepika Verma Hno.13,street 9,Jalandhar,Pu njab 1286723996 ICU and Critical Care Nurse
R502 N
N109 Neha Cheema Hno.11,street 8,Jalandhar,Pu njab 1286723967 Staff Nurse R405 N N110 Sharan kaur Hno.55,street 7,Jalandhar,Pu njab 6789124456 Staff Nurse R503 N Table 2.5: Nurse
GU-2020- Book: Simplified approach to DBMS by Dr. Prateek Bhatia, Dr. Gurvinder Singh. https://lucid.app/ Page 10
