6) The pair of attributes (carreg, hireDate) is a candidate key (True) 7) custNo custName is a transitive dependency (True) 8) Normalization is a process for evaluating and correcting table structures to minimize a) data redundancies b) the number of attributes c) the number of new tables created d) primary key values 9) Consider a relational schema R(A, B, C, D, E) with the following functional dependencies: A B, BC E, and ED A. Which one of the following is a key for R? a) BCD b) BC C) AC d) ABC 10) The CREATE statement is one type of a) DDL statement b) DML statement c) normalization statement d) relational statement 11) You need to ensure that any data that is entered into the Salary column of the Employee table falls within a range from $15,000 to $150,000. What should you create? a) CHECK Constraint b) DEFAULT C) DDL TRIGGER d) PRIMARY KEY Constraint 12) The following query is written for the purpose of retrieving a listing of customers that don't have phone numbers listed in the Customer table. The query does not return what was intended. SELECT LastName, FirstName, Phone FROM Customer WHERE Phone - NULL What would you do to make the query work? a) Replace WHERE Phone = NULL with WHERE Phone IS NULL b) Replace WHERE Phone = NULL with WHERE Phone="" c) Replace WHERE Phone = NULL with WHERE IS NOT NULL d) There is no problem with the query 13) Consider the relational database given below: employee (person name, street, City) works (person name, company name, salary) company (company name, city)