9 35 Examine Three Tables Student Data Shown Fig Ure 9 1 Design Single Table Format Hold D Q43821581
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 < 005 005 mln FIGURE 9-8 Periodic warehouse data Table X (10/09) Key Date А в Action 001 10/09 002 10/09 003 10/09 C 00410/09 Table X (10/10) Key Date в А Action Table X (10/11) Koy Date 001 10/09 A Action B C 001 10/09 002 10/09 cd 002 10/09 cd 002 002 10/10 003 10/09 OOOO 003 003 004 10/10 10/09 10/11 10/09 10/10 004 10/09 004 10/10 004 y 005 10/10m 004 10/11 005 10/10 mln Show transcribed image text 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
Expert Answer
Answer to 9-35. Examine the three tables with student data shown in Fig. ure 9-1. Design a single-table format that will hold all …
OR