(Solved) : 1 Many Records Rows Raw Data Table Store Many Fields Columns Attributes Record 2 Problem W Q34867886 . . .
1. How many records (rows of raw data)does the above table store, and how many fields (columns orattributes) are in each record?
2. What problem would you encounter ifyou wanted to list the records in order of the manager’s last name,or if you sometimes wanted to omit the first name or middle name ina display or printout? This design fault is referred to as acomposite attribute. Show the table structure ofan altered table that will correct this problem? Show all columnsand rows of raw data in this revised table.
3. What problem would you encounter ifyou wanted to list the records in order of the street address,city, state, or zip, or area code? Building upon the improvementsthat you’ve already made, show the table structure of an alteredtable that also corrects this problem? Show all columns and rows inthis revised table, including the new ones from Step 2.
4. What data redundancies do youdetect; i.e., what unnecessary repetitions are occurring? How couldthese redundancies lead to update anomalies, delete anomalies, orinsert anomalies?
5. Using two relational tables,PROJECT and MANAGER, eliminate the redundancies you identified inProblem 4. Create a ManagerID column in both tables so you can linkthe two tables with the ManagerID being the primary key in MANAGERand a foreign key in PROJECT. Identify the primary key in eachtable. With words, show how the two tables join together by aforeign key that references a primary key. A format that would beuseful is
Tablename.Columnname references Tablename.Columnname.
ForeignKey Primary Key
In this problem, show the column namesacross the top of each table and the rows of raw data below thecolumn names. The columns must correct all faults (compositeattributes and redundancies) that you saw above.
PROJECT_BID_PRICE PROJECT CODE- PROJECT-MANAGER. MANAGER-PHONE 21-5Z 25-2D 25-5A 25-9T 27-4Q 29-2D 31-7P MANAGER_ADDRESS Holly B. Parker Jane D. Grant George F. Dorts Holly B. Parker George F. Dorts Holly B. Parker William K. Moor 904-338-3416 615-898-9909 615-227-1245 904-338-3416 615-227-1245 904-338-3416 904-445-2719 3334 Lee Rd., Gainesville, FL 37123 218 Clark Blvd., Nashville, TN 36362 124 River Dr., Franklin, TN 29185 3334 Lee Rd., Gainesville, FL 37123 124 River Dr., Franklin, TN 29185 3334 Lee Rd., Gainesville, FL 37123 216 Morton Rd., Stetson, FL 30155 16833460.00 12500000.00 32512420.00 21563234.00 10314545.00 25559999.00 56850000.00 0.00 米 Show transcribed image text
Expert Answer
Answer to 1 Many Records Rows Raw Data Table Store Many Fields Columns Attributes Record 2 Problem W Q34867886 . . .
OR