Database Question PRICE(S) QUANTITY TOTAL(S) 9 190 38 13 INVOICE DATE CUSTOMER N
ID: 3876762 • Letter: D
Question
Database Question
PRICE(S) QUANTITY TOTAL(S) 9 190 38 13 INVOICE DATE CUSTOMER NAME Phone PRODUCT 1001 2014-03-08 00:00:00 Myron Orlando 1001 2014-03-08 00:00:00 Myron Orlando 1002 2014-03-08 00:00:00 Leona Dunne 1003 2014-03-08 00:00:00 Kathy Smith 1003 2014-03-08 00:00:00 Kathy Smith 1003 2014-03-08 00:00:00 Kathy Smith 1004 2014-03-09 00:00:00 Leona Dunne 1004 2014-03-09 00:00:00 Leona Dunne (615)222-1672 Rat-tail file (615)222-1672 Houselite chain saw, 16-in. bar 190 (713)894-1238 Sledge hammer, 16-lb. head 19 (615)894-2285 Claw hammer (615)894-2285 Steel tape, 12-ft. length (615)894-2285 Rat-tail file (713)894-1238 Claw hammer (713)894-1238 Rat-tail file 3 3 13 3 13 3 3 13 2 a) Is it possible to insert the data of a new product that has not been in the market yet? What type of anomaly is this? b) What will happen to the record of the customer Kathy Smith, if we delete the invoices 1003? What type of anomaly is this?Explanation / Answer
a)It is an insert anomaly, it occurs when we can't insert certain attributes without the presence of similar attributes already in table, means we can't insert details of new product unless we have at least one entry of corresponding product data..
b)it is an delete anomaly, it occurs when certain attributes are lost because of the deletion of one/other attribute...here if we delete invoices 1003, then all the attributes that contain invoice 1003 are deleted.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.