Primary and Secondary Keys

E6.2.a, E6.2.c, E6.2.g

Only point out which rows are affected (if any) do not have to show the entire table(s) when process is finished

Conformity 198 Consistency 198 Delete restrict 178 Delete set-to-default 180 Timeliness 198 Review Questions 1 List options for implementing referential integrity con- 06.2 What is the purpose of an index? 06.3 What is the purpose of database front-end applications? 0. 06.5 What is the purpose of a report? 06.6 Describe the advantage of a Web site that is an interface 06.1 Q6.8 Define data uniqueness Q6.9 Define data completeness. 06.10 Define data consistency 06.11 Define data timeliness 06.12 Define data conformity straints with regard to delete and update operations. 3 Give an example of a preventive data quality 06.14 Give an example of a corrective data quality actio What is the purpose of a with a database. Exercises on the referential integrity const SALES REP and TERRITORY, showt. oetw in tables SALES_REP and TERRITORd E6.1c If a DBMS enforces a DELETE RESTR Consider the two tables shown in Figure 6.37. The TerID column in the SALES REP relation is a foreign key re- ferring to the primary key column TerlD in the TERRI- E6.1 TORY relation. user tries to delete the first recod(, Joe Bftra E6.1a If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between SALES_REP and TERRITORY, show the records in tables SALES REP and TERRITORY after a user tries to delete the fourth record (N, North) SALES REP on the referential integrity constraint he SALES REP and TERRITORY, showw in tables SALES_REP andTERITO user tries to delete the fourth record from TERRITORY E6.1d If a DBMS enforces a DELETE CASO records (N, N from TERRITORY E6.1b If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between SALES_REP and TERRITORY, show the records in tables SALES REP and TERRITORY after a user tries to delete the second record (W, West) E6.1e If a DBMS enforces a DELETE CASCADE on the referential integrity constraint SALES REP and TERRITORY, showen in tables SALES_ REP and TERRITORY from TERRITORY. SALES REP TERRITORY SRID SRName TerlD TerlD TerName Sue W West South North C Central Pat 7 Lee 8 Joe FIGURE 6.37 The relations Sales_Rep and Territory