C 239:62 Spring 2018 Homework #1 Pa Answer these questions about Figure P 1.1 on Page 32 in the textbook: a) b) c) #9. How many records does it have? How many fields per record does it have? What redundancies do you see in the data? (Give 2.) #10. Answer these questions about Figure P1.9 on Page 33 in the textbook: a) What metadata can you tell from looking at the table contents? (Give 2.) b) What would happen if the building with the building code "KOM" were deleted? Name 5 tools / utilities that a DBMS provides, usually. Briefly explain each. #11 . #12. #13. List the 7 functions of a DBMS discussed during lecture. ( le. functionality a DBMS provides.) a) b) List the 5 Job titles given in the Lecture book ( Figure 1.10 Page 23) What other job titles/roles are needed? (refer to the lecture) C 239:62 Spring 2018 Homework #1 Pa Answer these questions about Figure P 1.1 on Page 32 in the textbook: a) b) c) #9. How many records does it have? How many fields per record does it have? What redundancies do you see in the data? (Give 2.) #10. Answer these questions about Figure P1.9 on Page 33 in the textbook: a) What metadata can you tell from looking at the table contents? (Give 2.) b) What would happen if the building with the building code "KOM" were deleted? Name 5 tools / utilities that a DBMS provides, usually. Briefly explain each. #11 . #12. #13. List the 7 functions of a DBMS discussed during lecture. ( le. functionality a DBMS provides.) a) b) List the 5 Job titles given in the Lecture book ( Figure 1.10 Page 23) What other job titles/roles are needed? (refer to the lecture)