SQL Assignment Unit 4 Bachelor's degree in computer science CS2203-01– AY2024-T3 Student: Eckert Schnetler Instructor: Instructor: Rupa Sarda.

Introduction: The administration of patient data remains a critical component of successful and efficient medical care in the constantly changing field of healthcare technology. The goal of the Hospital Software System project is to solve important issues with data retrieval and management, which are essential to the provision of healthcare. Healthcare databases now have more complicated data structures due to the growing reliance on digital records, which frequently results in inefficiencies and redundancies. The primary goal of this project is to normalize the hospital's database relations into first, second, and third normal forms. This is an essential step in maintaining data integrity, cutting down on redundancy, and improving patient access to critical information. By painstakingly …show more content…
This greatly improves the general standard of patient care, in addition to helping medical personnel obtain accurate and current patient information.

1. Normal Form (1NF): 1. Patient Relation: The "Allergies" attribute should not be in the list. Create a separate "Allergy" table with "PatientID" and "AllergyID" as a composite primary key. Each allergy is a separate row linked to a patient. 2. What is the difference between a'smart' and a'smart'? Appointment Relation: The "Medicine" attribute must be split into a separate "Medicine" table. This table will have "AppointmentID" and "MedicineID" as a composite primary key, with each