consider the following diagram. which of the following statements are correct? a. a new table will be created that contains both sales order id and product id as its composite primary key. b. credit sales are not allowed. c. the resulting database contains 9 tables in total. d. the same employee both process sales orders and collects cash.