The following table shows some simple student data as of the date 06/20/2010:
The following transactions occur on 06/21/2010:
• Student 004 changes major from Math to Business.
• Student 005 is deleted from the file.
• New student 006 is added to the file: Name is Jim, Major is Phys Ed.
The following transactions occur on 06/22/2010:
• Student 003 changes major from Art to History.
• Student 006 changes major from Phys Ed to Basket Weaving.
Your assignment involves two parts:
a. Construct tables for 06/21/2010 and 06/22/2010, reflecting these transactions; assume that the data are transient (refer to Figure 9-7).
b. Construct tables for 06/21/2010 and 06/22/2010, reflecting these transactions; assume that the data are periodic (refer to Figure 9-8).
Reference figure 9-7
FIGURE 9-7 Transient operational data
FIGURE 9-8 Periodic warehouse data
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.