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, hardcover). Price of the same book but different book format can be different. A book is uniquely identified by an 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 ISBN, Title, Author-Full-Name, Publishing-Company-ID) PUBLISHING COMPANY Publishing-Company-ID, Publishing-Company-Name) DEPARTMENT Dept-ID, Dept-Name, Manger-ID, Manager-Name) EMPLOYEE Employee-ID, Employee-First-Name, Employee-Last-Name, Dept-ID) BOOK PRICES ISBN, Book-Format, Book-Title) ch 5 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 BoOOKS and EMPLOYEE tables? (a) yes (b) no 10. If 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 (b) 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