Specify how a database management system (DBMS) could be used to preclude the problem.

In the file system shown below, one business rule is that each project has one manager. Identify two (and no more than two) problems with the data structure or inconsistencies with the data contents. Indicate why the items you posted are an issue.

 

Transcribed Image Text:

Project_Code Proj_Mgr_First Proj_Mgr_Last Project_Member Manager_Phone Member_Phone A. B. Smith Louis White Tom Fitts Joan Jen M. L. Jones L. Patel Annie Smith R. Patel Marylou Jones Ram Reddy 512-902-3897 302-873-2310 512-902-3897 312-983-9080 512-902-3897 903-573-2098 512-902-3879 999-999-9999 302-571-9856 613-534-9082 302-571-9856 614-348-2098 302-571-9856 302-873-2310 302-571-9856 614-348-2098 212-945-3476 613-534-9082 212-945-3476 512-902-3897 212-945-3476 903-573-2098 Tom Fitt 21-5 21 5 21-5 21-5 AA-J3 AA-J3 AA-J XL9 XL.9 XL.9 XL.9 Ram Ram Ram R. Mary Mary Mary Beth Lou Lou Lou Lou Reddy Reddy Reddy Reddy Brown Brown Brown Gaffrey Gaffree Gaffrey Gaffrey Manager_Address 21 Main St., Apt. A, Newtown, PA 12753 21A Main St., Newtown, PA 12753 21 Main St., Apt. A, Newton, PA 12753 21A Main Street, Newtown, PA 12753 54 Market St., Chestfield, DE 19820 54 Market St., Chestfield, DEL 19820 54 Market St., Chestfeild, DE 19820 54 Market St, Chestfield, DE 19820 6 Front Avenue, Springs, MD 14287 6 Front Avenue, Springs, Md 14287 6 Front Avenue, Springs, MD 14287 Member Street 78 Market St. 717 6th St 56 Main St. 76A Lancey Blvd 571 Lake Rd. 51 Rural Rd. 78 Market St. 51 Rural Road 571 Lake Rd. 21A Main St. 56 Main Street Member_City | Mem_State Mem_Zip Fulton CA 67245 Alton NJ 9867 Newtown Pa 12753 Albany CX 12980 Wilmington DE 19806 Cranston 13246 Fulton 67245 Cranston 13246 Wilmington 19806 Newtown 12753 Newton 12753 NY CA NY de PA PA Project Cost 1345.00 1345.00 1345.00 1345.00 29809.00 29809.00 29809.00 29809.00 26123.00 26123.00 26123.00 Project_Code Proj_Mgr_First Proj_Mgr_Last Project_Member Manager_Phone Member_Phone A. B. Smith Louis White Tom Fitts Joan Jen M. L. Jones L. Patel Annie Smith R. Patel Marylou Jones Ram Reddy 512-902-3897 302-873-2310 512-902-3897 312-983-9080 512-902-3897 903-573-2098 512-902-3879 999-999-9999 302-571-9856 613-534-9082 302-571-9856 614-348-2098 302-571-9856 302-873-2310 302-571-9856 614-348-2098 212-945-3476 613-534-9082 212-945-3476 512-902-3897 212-945-3476 903-573-2098 Tom Fitt 21-5 21 5 21-5 21-5 AA-J3 AA-J3 AA-J XL9 XL.9 XL.9 XL.9 Ram Ram Ram R. Mary Mary Mary Beth Lou Lou Lou Lou Reddy Reddy Reddy Reddy Brown Brown Brown Gaffrey Gaffree Gaffrey Gaffrey Manager_Address 21 Main St., Apt. A, Newtown, PA 12753 21A Main St., Newtown, PA 12753 21 Main St., Apt. A, Newton, PA 12753 21A Main Street, Newtown, PA 12753 54 Market St., Chestfield, DE 19820 54 Market St., Chestfield, DEL 19820 54 Market St., Chestfeild, DE 19820 54 Market St, Chestfield, DE 19820 6 Front Avenue, Springs, MD 14287 6 Front Avenue, Springs, Md 14287 6 Front Avenue, Springs, MD 14287 Member Street 78 Market St. 717 6th St 56 Main St. 76A Lancey Blvd 571 Lake Rd. 51 Rural Rd. 78 Market St. 51 Rural Road 571 Lake Rd. 21A Main St. 56 Main Street Member_City | Mem_State Mem_Zip Fulton CA 67245 Alton NJ 9867 Newtown Pa 12753 Albany CX 12980 Wilmington DE 19806 Cranston 13246 Fulton 67245 Cranston 13246 Wilmington 19806 Newtown 12753 Newton 12753 NY CA NY de PA PA Project Cost 1345.00 1345.00 1345.00 1345.00 29809.00 29809.00 29809.00 29809.00 26123.00 26123.00 26123.00