name n NOTE: Use the following five tables to answer Questions 1-15. Questions 16-20 are general questions that do not require these tables. Also: (1) these tables may or may not be normalized. (2) ISBN and all ID columns are Weak e attribu primai numeric Integer) data type. The following tables are for bookstore database. A book is written by one or more authors and is published by one publishing company. Each book has one title but it can have multiple formats (such as digital, paperback mul surge The r key A ISBN. The bookstore has four departments and employs a number of employees; each employee works in only one department. Each department has a manager BOOKS aSBN, Title, Author-Full-Name, Publishing-Company-ID) PUBLISHING COMPANY DEPARTMENT Dept-ID, Dept-Name, Manger-ID, Manager-Name) EMPLOYEE BOOK PRICES ISBN, Book-Format, anot Publishin-Company-ID, Publishing-Company-Name) efer co able Emplovee-ID, Employee-First-Name, Employee-Last-Name, Dept-ID) Book-Title) fe 1. Which of the following tables has a composite attribute? va (a) BOOKS (b) PUBLISHING COMPANY (c) EMPLOYEE (d) none of the above 2. Relationship between BOOKS and PUBLISJING COMPANY tables is: (a) Week (b) Strong (c) Identifying 3. Which of the following is a multi-valued attribute in EMPLOYEE table? 4. Which of the following tables does not have a foreign key? If all have foreign keys then select d 5. Which of the following tables has two primary keys? (a) Employee-first-name (b) Employee-last-name (c) Dept-ID (d) none of the above (a) BOOK (b) BOOK PRICES(c) PUBLISHING COMPANY (d) all have foreign keys (a) BOOKS b) PUBLISHING COMPANY (c) DEPARTMENT (d) none of the above 6. Are EMPLOYEE and DEPARTMENT tables union compatible?? (a) yes (b) no 7. Can the inner ioin operation be performed on BOOKS and BOOK PRICES tables? (a) yes (b) no 8. Which of the following functional dependence is yalid? If all are valid, select d. If all are not valid select e. (a) ISBN-> Publishing-company-name (b) Book-Price-> ISBN (c) Dept-ID ->Employee-ID (d) all are valid (e) all are not valid 9. Can we perform INTERSECTION operation on BOOKS and EMPLOYEE tables? (a) yes (b) no we enforce referential integrity between EMPLOYEE and DEPARTMENT tables, then: (a) we cannot enter a NULL value in the Dept-ID column of the EMPLOYEE table any data value entered in the Dept-ID column of the EMPLOYEE table must have a matching data value in the Dept-ID column of the DEPARTMENT table. (c) none of the above