Hide Assignment Information

Instructions

Purpose:

This assignment is designed to examine your level of understanding to the data warehousing technologies.

Assignment:

1. The following table shows some simple student data as of the date 06/20/2018:

Key	Name	Major
001	Amy	Music
002	Tom	Business
003	Sue	Art
004	Joe	Math
005	Ann	Engineering

The following transaction occur on 06/21/2018:

• 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/2018:

• 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 from 06/21/2018 and 06/22/2018, reflecting these transactions; assume the data aretransient;

b) Construct tables from 06/21/2018 and 06/22/2018, reflecting these transactions; assume the data areperiodic.