Database Theory Assignment 1 Essay

688 Words Feb 21st, 2014 3 Pages
1) How many records does the file contain? How many fields are there per record?
There are 7 records (21-5Z through 31-7P) and each record contains 5 fields (PROJECT_CODE through PROJECT_BID_PRICE).

2) What problem would you encounter if you wanted to produce a listing by city? How could you solve this problem by altering the file structure?
There is not a field for city, only manager’s address. In order to get a listing by city, you would have to break up the address into address, city, state, zip, file format. You can do an internal string search, but it is difficult to write and takes longer to execute.

3) If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you
…show more content…
6) Looking at the EMP_NAME and EMP_PHONE contents in Figure P1.5, what change(s) would you recommend?
I would have the fields set up as first name (EMP_FIRST), middle initital, (EMP_INITIAL), last name (EMP_LAST), area code (EMP_AREACODE), phone (EMP_PHONE).

7) Identify the various data sources in the file you examined in Problem 5.
Employee data (names and phone numbers), project data (project name), and job data (charge per hour and project hours).

8) Given your answer to Problem 7, what new files should you create to help eliminate the data redundancies found in the file shown in Figure P1.5?
Project file should contain project characteristics (name, manager/coordinator, budget), employee file should contain employee information (name, phone number, address, employee number), job file should contain billing charges per hour for each job type , and a charge file should keep track of the number of hours by job type being billed for each employee who worked on the project.

9) Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.9. (This file is meant to be used as a teacher class assignment schedule. One of the many problems with data redundancy is likely occurrence of data inconsistencies-two different initials have been entered for the teacher Maria Cordoza.)
There are multiple entries for every teacher. If any person

More about Database Theory Assignment 1 Essay