Top Posters
Since Sunday
g
3
3
2
J
2
p
2
m
2
h
2
s
2
r
2
d
2
l
2
a
2
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
Danli Danli
wrote...
Go to Answer
Posts: 1536
Rep: 0 0
7 years ago
Explain deletion anomalies and provide examples.
Textbook 
Hands-On Database

Hands-On Database


Edition: 2nd
Author:
Read 137 times
3 Replies
Computer Science Major @ The University of Texas at Austin
Replies
Answer verified by a subject expert
VenturiaVenturia
wrote...
#1
Posts: 265
Rep: 6 0
7 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here
1

Related Topics

wrote...
#2
Valued Member
7 years ago
A Delete Anomaly exists when certain attributes are lost because of the deletion of other attributes. For example, consider what happens if Student S30 is the last student to leave the course - All information about the course is lost.
Table--
StudentNumber   CourseNumber   Student Name   Address            Course
S21                      8201                 Jess         London            Accounts  
S21                  8267                         Leesa            Uae             Accounts
S24              8267                        Smith            Glasgow       Physics
S30                       8203                       Alisha          Manchester    Chemistry
Danli Author
wrote...
#3
7 years ago
This is exactly what was needed for the quiz, thank you
Computer Science Major @ The University of Texas at Austin
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  814 People Browsing
 124 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 8260
  
 221
  
 414