IDS 521 Extra Assignment (Fall 2018) - This Assignment is Worth 3%
Due date: submit the answers to this assignment to the Blackboard by 11:59PM on 11/10/2018.
To do this extra assignment, you may work in a group of up to two students per group.
1. (10%) Consider the following organization rollup structure diagram (see Figure 7-8 below). The classic way to
represent this rollup structure is by placing recursive pointers in the organization (corporate firm) dimension
table from each row to its parent (see Figure 7-10 below).
Suppose that you want to implement the classic parent/child recursive design in SQL Server. Your task for the
first question is to create a SQL Server database (name it ExtraHwkDB) that contains a single table, say Firm
table. The Firm table, which represents the rollup structure shown in Figure 7-8, should look like the
following (Firm_ID, Rollup_Level, and Firm_Parent are of data type integer, Firm_Name is of data type
Varchar of size 10)