Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Issues In Database Management A Refernce For The Thinking Practitioner

Authors: Fabian Pascal

1st Edition

0201485559, 978-0201485554

More Books

Students also viewed these Databases questions