deletion anomaly

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
icon
Related questions
Question

Which of the following will cause a deletion anomaly in the following table?

  1. Deleting surgery with surgeryNo S10.
  2. Deleting all appointments of Jill Bell.
  3. Deleting all appointments of Ian MacKay

A) 1 and 2

B) 1 and 3

C) 2 and 3

D) All three

staffNo dentistName patNo patName
appointment
date
surgeryNo
time
Tony Smith
Tony Smith
Helen Pearson P108
S1011
P100
Gillian White | 12-Sep-13
10.00 S15
S1011
P105
Jill Bell
12-Sep-13
12.00 | S15
Ian MacKay 12-Sep-13
Ian MacKay 14-Sep-13
S1024
10.00 | S10
S1024
Helen Pearson P108
14.00 S10
S1032
Robin Plevin
P105
Jill Bell
14-Sep-13 16.30 S15
S1032
Robin Plevin
P110
John Walker
15-Sep-13
18.00 | S13
Transcribed Image Text:staffNo dentistName patNo patName appointment date surgeryNo time Tony Smith Tony Smith Helen Pearson P108 S1011 P100 Gillian White | 12-Sep-13 10.00 S15 S1011 P105 Jill Bell 12-Sep-13 12.00 | S15 Ian MacKay 12-Sep-13 Ian MacKay 14-Sep-13 S1024 10.00 | S10 S1024 Helen Pearson P108 14.00 S10 S1032 Robin Plevin P105 Jill Bell 14-Sep-13 16.30 S15 S1032 Robin Plevin P110 John Walker 15-Sep-13 18.00 | S13
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Distributed Database Concepts
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education