9-27. The following table shows some simple album and price data as of the date
ID: 3869849 • Letter: 9
Question
9-27. The following table shows some simple album and price data as of the date 07/18/2015:
Key Album Price(in dollars)
K1 Superhits 5
K2 1990s 4
K3 Beatles 10
K4 Classics 8
K5 AllTime 6
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: Name is PopFavorites,
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).
Explanation / Answer
a) When data is transient
07/19/2015
Key Album Price(in dollars)
K1 Superhits 5
K2 1990s 4
K3 Beatles 7
K4 Classics 8
K6 PopFavorites 9
07/20/2015
Key Album Price(in dollars)
K1 Superhits 5
K3 Beatles 10
K4 Classics 6
K5 AllTime 6
b) When data is periodic
07/19/2015
Key Album Price(in dollars)
K1 Superhits 5
K2 1990s 4
K3 Beatles 7
K4 Classics 8
K6 PopFavorites 9
07/20/2015
Key Album Price(in dollars)
K1 Superhits 5
K3 Beatles 7
K4 Classics 6
K6 PopFavorites 9
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.