So if I have this table:staffNodentistNamepatientNopatientNameappointment_dateappointment_timesurgery_noS1011Tony SmithP100Gillian White12-Aug-0310:00S10S1011Tony SmithP105Jill Bell13-Aug-0312:00S15S1024Helen PearsonP108Ian MacKay12-Sep-0310:00S10S1024Helen PearsonP108Ian MacKay14-Sep-0310:00S10S1032Robin PlevinP105Jill Bell14-Oct-0316:30S15S1032Robin PlevinP110John Walker15-Oct-0318:00S13 Here the non-trivial functional relations include at least the following:staffNo --> dentistNamepatientNo -->patientNamepartientNo, appointment_date, appointment_time --> surgery_noDo you believe there are other functional dependencies? If so, what are they? If not, why not? Do you believe it would help to create additional attributes during normalization? If so, what are they? If not, justify why it's not needed.How do I draw this out?

Based on the provided data, I've identified the functional dependencies, and it appears there are no…

Answered: o if I have this table: staffNo…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

So if I have this table:

staffNo	dentistName	patientNo	patientName	appointment_date	appointment_time	surgery_no
S1011	Tony Smith	P100	Gillian White	12-Aug-03	10:00	S10
S1011	Tony Smith	P105	Jill Bell	13-Aug-03	12:00	S15
S1024	Helen Pearson	P108	Ian MacKay	12-Sep-03	10:00	S10
S1024	Helen Pearson	P108	Ian MacKay	14-Sep-03	10:00	S10
S1032	Robin Plevin	P105	Jill Bell	14-Oct-03	16:30	S15
S1032	Robin Plevin	P110	John Walker	15-Oct-03	18:00	S13

Here the non-trivial functional relations include at least the following:

staffNo --> dentistName

patientNo -->patientName

partientNo, appointment_date, appointment_time --> surgery_no

Do you believe there are other functional dependencies? If so, what are they? If not, why not? Do you believe it would help to create additional attributes during normalization? If so, what are they? If not, justify why it's not needed.

How do I draw this out?

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions