ITEC 340
Homework 7
Create a Single spreadsheet with two pages named hw7.xls
Problem A - Paste the following table of track meet results into the first page of your spreadsheet. Rename that sheet to Problem A.
Below the original table, construct a set of normalized tables that illustrates the same data. Be sure to identify all PKs with underlining. Be sure to name your tables.
Students
|
Lastname |
Firstname |
Test
1 |
Test
2 |
Test
3 |
Test
4 |
Quiz
1 |
Quiz
2 |
Quiz
3 |
Quiz
4 |
|
Smith |
Robert |
78 |
83 |
88 |
|
10 |
8 |
|
|
|
Thompson |
Richard |
84 |
77 |
81 |
|
10 |
7 |
|
|
|
|
Sallie |
100 |
91 |
94 |
|
9 |
10 |
|
|
|
Morgan |
Ray |
55 |
|
78 |
|
8 |
8 |
|
|
Problem B - Paste the following table of students into the second page of your spreadsheet. Rename that sheet to Problem B.
Below the original table, construct a set of normalized tables that illustrates the same data. Be sure to identify all PKs with underlining. Be sure to name your tables
Faculty
|
FID |
Lname |
Fname |
RankCode |
RankDescription |
OfficePhone |
DeptCode |
Dept
Phone |
Dept
Address |
|
1 |
Jones |
Roger |
Asso |
Associate Professor |
555-1001 |
Math |
555-1000 |
Room 32 Fermet
Hall |
|
2 |
Smith |
Sally |
Full |
Full Professor |
555-2012 |
Biology |
555-4000 |
Room 21 Darwin Hall |
|
3 |
Johnson |
Jane |
Asso |
Associate Professor |
555-8563 |
Biology |
555-4000 |
Room 21 Darwin Hall |
|
4 |
Barnes |
Fred |
Assi |
Assistant Professor |
555-9932 |
Math |
555-1000 |
Room 32 Fermet
Hall |
|
5 |
Timmons |
John |
Full |
Full Professor |
555-5231 |
English |
555-2200 |
Room D2 Emerson Hall |
Submit your homework to the dropbox in an RU07 folder by 5:00 Thursday, March 24th.