9-35. Examine the three tables with student data shown in Fig. ure 9-1. Design a single-table format that will hold all of the data (nonredundantly) that are contained in these three tables. Choose column names that you believe are most appropriate for these data. 9-36. The following table shows some simple album and price data as of the date 07/18/2015: Price (in dollars) K2 Album Superhits 1990s Beatles Classics AllTime K3 K4 K5 The following transactions occur on 07/19/2015: Album K3 price discounted to $7. Album K5 is deleted from the file. New album K6 is added to the file: the name is PopFa- vorites, Price is $9. The following transactions occur on 07/20/2015: Album K4 price discounted to $6. Album K2 is deleted from the file. Your assignment involves two parts: a. Construct tables for 07/19/2015 and 07/20/2015, reflecting these transactions; assume that the data are transient (refer to Figure 9-7). b. Construct tables for 07/19/2015 and 07/20/2015, reflecting these transactions; assume that the data are periodic (refer to Figure 9-8). 9. Data Warehousing and Data Integration STUDENT DATA FIGURE 9-1 Examples of heterogeneous data StudentNo LastName MI FirstName Telephone Status ... 123-45-6789 Enright T Mark 483-1967 Soph 389-21-4062 Smith IR Elaine 283-4195 STUDENT EMPLOYEE StudentID Address Dept Hours 123-45-6789 1218 Elk Drive, Phoenix, AZ 91304 Soc 8 389-21-4062 134 Mesa Road, Tempe, AZ 90142 Math 10 STUDENT HEALTH Student Name Telephone Insurance ID Mark T. Enright 483-1967 Blue Cross 123-45-6789 Elaine R. Smith 555-7828 ? 389-21-4062 9. Data Warehousing and Data Integration 437 Table X (10/09) FIGURE 9.7 Transient operational data 001 002 tu 003 004 Table X (10/10) Table X (10/11) Key 001 001 002 lo - 002 003 004 003 PRO