Determine the functional dependences. Eg. Patient_ID → Pname, , ......, ......Normalise these tables. Make the normalization to 3NF and explain every step in the process.
Assume that you are the
User view 1 requirement: The database should have information about Patients, Doctors, Appointments Bills and Payments.
User view 2 requirements: Database system will store Patient’s details such as-Patient_ID, name, phone, email and home_address. Patients can make one or more appointments. However, one appointment is scheduled with only one patient. Patients can make several payments to the system, each payment belongs to only one patient.
User view 3 requirements: Each doctor has an identification number and his/her name, telephone number, email and speciality should be recorded in the database. Examples for Doctor’s speciality - Cardiologist, Orthopaedics, Oncologists, Urologist, ..etc.(Note: It is a multi-valued attribute).
User view 4 requirements: It is required to keep track of Appointment_number, Appoinmet_date, time and reason for the appointment. Each doctor can have zero or many appointments, however each appointment is scheduled with exactly one doctor. Each appointment will generate one bill with Bill number, bill date, Appointment_number and patient_ID.
Determine the functional dependences. Eg. Patient_ID → Pname, , ......, ......Normalise these tables. Make the normalization to 3NF and explain every step in the process.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
