How many records does the file contain? How many fields are there per record?

What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure?

If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the file structure?

What data redundancies do you detect? How could those redundancies lead to anomalies?

P2-Make up the info for a Computer Science major's classes

Create an Excel Spreadsheet using the template and enter your class schedule using actual data.

Enter the class schedule of five of your classmates into the same Excel spreadsheet. For online students: You can make up the data.

Discuss the redundancies and anomalies caused by the design.

Room Number is the last one.

Problem 1 Problem 2 Problem 1 \begin{tabular}{|c|c|c|l|c|} \hline Project Code & \multicolumn{1}{c|}{ Project Manager } & Manager Phone & \multicolumn{1}{c|}{ Manager Address } & \multicolumn{1}{c|}{ Project Bid Price } \\ \hline 21-ZE & Holly B. Parker & 9043383416 & 23334 Rodan Rd. Gainesville, FL 327123 & $16,633,460.00 \\ \hline 25-2D & Jane D. Grant & 6158888808 & 215 Godzilla Place Nashville, TN 36362 & $12,500,000.00 \\ \hline 25-A5 & George F. Doris & 6152271245 & 124 Gidorah Dr. Franklin, TN 29166 & $32,512,450.00 \\ \hline 25-9T & Holly B. Parker & 9042283416 & 3334 Rodan Rd. Gainesville, FL 37123 & $10,614,545.00 \\ \hline 27-4Q & George F. Doris & 6152271245 & $24 Gidorah Dr. Franklin, TN 29166 & $25,999,999.00 \\ \hline William K. More & 9044452719 & Way Norfolk, VA 23515 & $20,000,000.00 \\ \hline \end{tabular} Student Schedule Data Format Problem 1 Problem 2 Problem 1 \begin{tabular}{|c|c|c|l|c|} \hline Project Code & \multicolumn{1}{c|}{ Project Manager } & Manager Phone & \multicolumn{1}{c|}{ Manager Address } & \multicolumn{1}{c|}{ Project Bid Price } \\ \hline 21-ZE & Holly B. Parker & 9043383416 & 23334 Rodan Rd. Gainesville, FL 327123 & $16,633,460.00 \\ \hline 25-2D & Jane D. Grant & 6158888808 & 215 Godzilla Place Nashville, TN 36362 & $12,500,000.00 \\ \hline 25-A5 & George F. Doris & 6152271245 & 124 Gidorah Dr. Franklin, TN 29166 & $32,512,450.00 \\ \hline 25-9T & Holly B. Parker & 9042283416 & 3334 Rodan Rd. Gainesville, FL 37123 & $10,614,545.00 \\ \hline 27-4Q & George F. Doris & 6152271245 & $24 Gidorah Dr. Franklin, TN 29166 & $25,999,999.00 \\ \hline William K. More & 9044452719 & Way Norfolk, VA 23515 & $20,000,000.00 \\ \hline \end{tabular} Student Schedule Data Format