The column characteristics for the tables are shown in Figures 2-47, 2-48, and 2-49. The relationship between CUSTOMER and INVOICE should enforce referential integrity, but not cascade updates nor...

The column characteristics for the tables are shown in Figures 2-47, 2-48, and 2-49. The relationship between CUSTOMER and INVOICE should enforce referential integrity, but not cascade updates nor deletions, while the relationship between INVOICE and INVOICE_ ITEM should enforce referential integrity and cascade both updates and deletions. The data for these tables are shown in Figures 2-50, 2-51, and 2-52. You will need to create and setup a database named MDC_CH02 for use with these case questions. A Microsoft Access 2013 database named MDC_CH02.accdb, and SQL scripts for creating the MDC_CH02 database in Microsoft SQL Server, Oracle Database, and MySQL are available on our Web site at www.pearsonglobaleditions.com/kroenke. If you are using the Microsoft Access 2013 MDC_CH02.accdb database, simply copy it to an appropriate location in your Documents folder. Otherwise, you will need to use the