D) Sequential E) None of the above. 16. Select the best answer. Data modeling is essentially: A) Drawing entities and attributes of those entities B) Documenting business rules and policies of an organization that govern data C) Storing large files of data D) Sharing large files of data. E) None of the above 17. A method to allow adjacent secondary memory space to contain rows from several tables is called: A) cluttering B) clustering c) concatenating D) compiling. 18. A key decision in the physical design process is: A) ignoring the size of the database. 8) selecting structures C) deciding on the monitor D) deciding the e-r diagrams of where and when data are used in 19. Designing physical files requires various ways a) maps B) descriptions C) keys D) hints 20. The smallest unit of application data recognized by system softuare is a: A) field B) row. C) data type D) column 21. (20 Points) The relation PART_SUPPLIER (Part No, Description, Vendor Name Vendor_Address, Unit_Cost) below contains sample data for parts and for vendors who supply those parts. The composite primary key of this relation is Part No The meaning of each row in PART SUPPLIER relation (see below) is that a particular vendor supplies a particular part at a certain unit cost. In discussing these data with users, the database analyst found that part numbers (but not descriptions) uniquely identify parts, and that vendor names uniquely identify and a single part might be supplied by different vendors. Please answer each ot the following questions: a. Draw a relational schema for this relation and show the functional vendors. Moreover, a single vendor may supply multiple parts dependencies. b. In what normal form is this relation? c. If this relation is not in third normal form, normalize the relation so t the resulting relations are in third normal form. Underline the primary how an arrow from the foreign key to its corresponding primary key and s SUPPLIER No Description Vendor Address Cupertino Phoenix Unit Cost Vendor Name Fast Chips Smart Chips 10.00 8.00 3.00 ic Chi