This assessment aligns with the Specific Learning Outcomes:

$1\mathrm{.}1$ Define basic database terminology

$1\mathrm{.}2$ Describe database management systems

$1\mathrm{.}3$ Understand the $3$ phases of database design

Introduction

Given the file structure shown in Figure P$1\mathrm{.}1,$ answer problems $1-4.$

PROJECT$\_$CODE PROJECT$\_$CODEPROJECT$\_$MANAGER PROJECT$\_$CODEMANAGER$\_$PHONE PROJECT$\_$CODEMANAGER$\_$ADDRESS PROJECT$\_$CODEPROJECT$\_$BID$\_$PRICE

$21-5$Z Holly B$.$ Parker $904-338-34163334$ Lee Rd$.,$ Gainesville, FL $3712316833460\mathrm{.}00$

$25-2$D Janet D$.$ Grant $615-898-9909218$ Clark Blvd$.,$ Nashville, TN $3636212500000\mathrm{.}00$

$25-5$A George F$.$ Dorts $615-227-1245124$ River Dr$.,$ Franklin, TN $2918532512420\mathrm{.}00$

$25-9$T Holly B$.$ Parker $904-338-34163334$ Lee Rd$.,$ Gainesville, FL $3712321563234\mathrm{.}00$

$27-4$Q George F$.$ Dorts $615-227-1245124$ River Dr$.,$ Franklin, TN $2918510314545\mathrm{.}00$

$29-2$D Holly B$.$ Parker $904-338-34163334$ Lee Rd$.,$ Gainesville, FL $3712325559999\mathrm{.}00$

$31-7$P William K$.$ Moor $904-445-2719216$ Morton Rd$.,$ Stetson, FL $3015556850000\mathrm{.}00$

Figure P$1\mathrm{.}1$

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