Question
Help with Relations 1NF,2NF,3NF The relation gives Doctor/Patient app data. A patient is given an appointment at a time and date with a doctor located
Help with Relations 1NF,2NF,3NF
The relation gives Doctor/Patient app data. A patient is given an appointment at a time and date with a doctor located at a operation room. On each day of patient app, a doctor is selected to the specified operation for that day.
-Is this a 1NF (Y)/(N)?if not transform it into 1NF and show data records in the relation in 1NF.
-Identify functional dependencies in the relation in 1NF also Identify partial functional dependency or transitive functional dependency
-Is this a 2NF and 3NF (Y)/(N)? If not transform the relation into a relational model in 2NF and then 3NF.
DoctoriD DoctorName PatientDPatientName AppDate James Ray James Ray George Tay 12-June-2016 1:00 11-Dec-2016 7:00 13-July-2016 11:00 R15 App Time OpperationRoom R03 R12 455 JohnJones1 1104 343 MatHisn 104 Tiffany Cross 11-0ct-2015 9:00 R13 05-Aug-2015 9:00 odi Seal 201Kiam Jotmscon 10May-2016 140 1563 R14
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started