Data base - MIS

Homework #1 The homework is to be done in group of no more than three students. Description: You are provided with a case which will be used for the assignments dealing with design and implementation of database. The purpose it to help translate material covered in class to a case that introduces you to some of the complexities of real world scenario. For this assignment -- you are instructed to use only two specific items from the case (both of which are included in this document):

 Figure PAS-1 (Sample 1, and Sample 2); and Figure PAS-2 (Sample 1) For each item above, you are required to do the following: Part #1 (30 points)

1. In each figure, the lists you are required to create are clearly marked in a red box. Using MS-Excel, create the separate lists for Figure PAS-1. The information that needs to be stored in each list, and the name of the list are shown in the figure below (marked in red). All the lists should be on a single worksheet. Name the worksheet Design Bid

a. Each list should contain appropriate column names. b. Enter the data provided for the two different Design Bids samples into each list (provided below).

2. Using MS-Excel, create separate lists for Figure PAS-2. The information to be contained in each list, and the name are shown in the figure below. All the lists should be on a single worksheet. Name the worksheet Production Plan

a. List should contain appropriate column names. b. Enter the data provided for the Production Plan below.

Part #2 (30 points) 3. For Design Bid

On a worksheet named Design Bid Themes a. For each list from Part #1

i. For each list: show the list from Part #1 with only the column names ii. For each list: identify all the different themes.

 Name each theme appropriately  Include the columns included in that theme.

Note: a column must not repeat in two different themes.  Include only two rows of data from Part #1 under each theme. Only when two rows of

data is not available, include only one row. 4. For Production Plan List

On a worksheet named Production Plan Themes a. For each list from Part #1

i. For each list: show the list from Part #1 with only the column names ii. For each list: identify all the different themes.

 Name each theme appropriately  Include the columns included in that theme.

Note: a column must not repeat in two different themes.  Include only two rows of data from Part #1 under each theme. Only when two rows of

data is not available, include only one row. Part #3 (40 points) [To be completed in PowerPoint. Each on separate slide]

5. Convert all the themes from Design Bid List into Tables a. Introduce additional columns as necessary b. Include the rows of data in each table (from Part #2). c. Show reference arrows for columns (as in lecture slides)

6. Convert all the themes from Production Plan List into Tables a. Introduce additional columns as necessary b. Include the rows of data in each table (from Part #2). c. Show reference arrows for columns (as in lecture slides)