The following tables are for bookstore database. A book is written by one or mor

Question

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 (Emplovee-ID, Employee-First-Name, Employee-Last-Name, Dept-ID) BOOK PRICES ISBN, Book-Format, Book-Title 1. Which of the following tables has a 2. Relationship between BOOKS and PUBLISJING COMPANY tables is: 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 (a) BOOKS (b) PUBLISHING COMPANY (c) EMPLOYEE (d) none of the above (a) Week (b) Strong (c) Identifying (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 5. Which of the following tables has two primary keys?

Explanation / Answer

Books is the rigth answer (Author - full name , this is composite attribute , as it can be further devided i.e Atomic attribute , for eg. Suppose Author name is Varun Setia it is composite as it can be devided , Varun as first name and Setia as Last Name ) Identifying(books is a strong entity as it has unique id i.e. isbn but publishing company is a weak entity as it has no unique id as all the books are published by only one company and if the primary key of weak entity is dependent or formed by the primary key of strong entity it is identifying ) none of these (first name is single valued , last name is also single valued and the dept id is also single valued as it has only one possible value , eg of multivalued is mobile number, the employee can have more than one no , so mob no is multivalued) here publishing company does not have foreign key(foreign key is the one in which the primary key of one table is used as reference to another table for eg: books has a primary key that is isbn , which is used as a refering key and here the refering key i.e isbn no will give us the detail about book price (book price table)) none of the above(books has isbn as its primary key,)

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.