Question: 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

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?

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

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.

per record? What problem would you encounter if you wanted to produce

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Topic 1 Database Systems Tutorial Questions for Week 2-3 1. Discuss each of the following terms: a data b. field C. record d. file 2. What is data redundancy, and which characteristics of the file...

Follow these instructions to complete your assignment: Click the Problem 1 tab below. Given the file structure shown, answer the following questions in a Word document: How many records does the file...

Directions: Given the file structure shown in Figure P1.1, answer Problems 1 - 4. Refer to Module 1 in the course for directions on submitting the completed file. Point values are listed after each...

Solve the problem Figure 1. File structure for Problems 1-4 PROJECT_CODE PROJECT_MANAGER MANAGER_PHONE MANAGER_ADDRESS 21-5Z Holly B. Parker 904-338-3416 3334 Lee Rd., Gainesville, FL 37123 25-2D...

Figure 1. the file structure for problem 1-4 PROJECT_CODE PROJECT_MANAGER MANAGER_PHONE MANAGER_ADDRESS 21-5Z Holly B. Parker 904-338-3416 3334 Lee Rd., Gainesville, FL 37123 25-2D Jane D. Grant...

Given the file structure shown in Figure P1.1, answer Problems 1-4. 1. How many records does the file contain? How many fields are there per record? 2. What problem would you encounter if you wanted...

FIGURE P1.1 THE FILE STRUCTURE FOR PROBLEMS 1-4 PROJECT_CODE PROJECT MANAGER MANAGER_PHONE 21-5Z Holly B. Parker 25-20 Jane D. Grant 25-5A George F. Dorts 25-9T Holly B. Parker 27-4Q George F. Dorts...

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...

FIGURE The file structure for Problems 14 P1.1 Given the file structure shown in Figure P1.1, answer Problems 1-4. 1. How many records does the file contain? How many fields are there per record? 2....

This assessment aligns with the Specific Learning Outcomes: 1 . 1 Define basic database terminology 1 . 2 Describe database management systems 1 . 3 Understand the 3 phases of database design...

Most countries, including the United States, import substantial amounts of goods and services from other countries. Yet the chapter says that a nation can enjoy a high standard of living only if it...

Gaseous propane mixes with air, both supplied at 500 K, 0.1 MPa. The mixture goes into a combustion chamber and products of combustion exit at 1300 K, 0.1 MPa. The products analyzed on a dry basis...

2 pts The MACRS depreciation method... allows less total depreciation to be claimed than other methods. None of the above combines accelerated and straight - line depreciation methods using pre -...

What is the expected return on an equally weighted portfolio of these three stocks? A. 9.23% B. 4.11%

Understand key international issues concerning: learning, training and talent development; high-performance working systems; worklife balance and diversity and equality.

1. What do employees who have family with special needs have to consider when accepting an international assignment?

understand the key issues concerning international assignments