Week 6 Textbook assignments - 8. Data redundancies might...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
8. Data redundancies might lead to the following three data anomalies: Update anomalies – Modifying one attribute for one entity would require changes in each table with that corresponding entity. Insertion anomalies – When a fictitious entity must be created to complete the data entry of another entity. Deletion anomalies – When a fictitious entity must be created just to save the data in a table that is link to the fictitious. 10. A surrogate key is an artificial PK (Primary key) used by the designer with the purpose of simplifying the assignment of primary keys to tables. Surrogate keys are usually numeric, they
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/02/2009 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Summer '08 term at Pennsylvania State University, University Park.

Ask a homework question - tutors are online