1. 2. 3. What is the difference between a database and a DBMS? What is the motivation for modern database systems? What is a DBMS, and what are its functions? Given the file structure shown in Figure P1.1, answer Questions 4 and 5 FIGURE P1.1 PROJECT CODE PROJECT MANAGER MANAGER PHONE 21-52 25-2D 25-5A 25-9T 27-40 29-2D 31-7P MANAGER ADDRESS PROJECT BID PRICE 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., Gainesvlle, FL 37123 216 Morton Rd., Stetson, FL 30155 16833460.00 12500000.00 32512420.00 21563234.00 10314545.00 25559999.00 56850000.00 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? What data redundancies do you detect? How could those redundancies lead to anomalies? 4. 5. Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.2 below 6. FIGURE P1.2 The File Structure PROJ NUM PROJ NAME EMP NUM EMP NAME JOB CODE JOB CHG HOUR PROJ HOURS EMP PHONE 1 Hurricane 1 Hurricane 1 Hurricane 2 Coast 2 Coast 3 Satellite 3 Satellite 3 Satelite 3 Satellite 101 John D. Newson EE 105 David F. Schwann CT 110 Anne R. Ramoras CT 101 John D. Newson EE 108 June H. Sattlemeir EE 110 Anne R. Ramoras CT 105 David F. Schwann CT 123 Mary D. Chen 11 2 Allecia R. Smith BE 85.00 60.00 60.00 85.00 85.00 62.00 26.00 85.00 85.00 13.3 653-234-3245 16.2 653-234-1123 14.3 615-233-5568 19.8 653-234-3254 17.5 905-554-7812 11.6 615-233-5568 23.4 653-234-1123 19.1 615-233-5432 20.7 615-678-6879 7. Looking at the EMP NAME and EMP PHONE contents in Figure P1.2, what change(s) would you recommend