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 composite attribute? (a) BOOKS (b) PUBLISHING COMPANY (c) EMPLOYEE (d) none of the above 2. Relationship between BOOKS and PUBLISJING COMPANY tables is: (c) Identifying (b) Strong (a) Week (a) Employee-first-name (a) BOOK . Which of the following is a multi-valued attribute in EMPLOYEE table? (b) Employee-last-name (c) Dept-ID (d) none of the above 4. Which of the following tables does not have a foreign key? If all have foreign keys then select d (b) BOOK PRICES (c) PUBLISHING COMPANY (d) all have foreign keys . Which of the following tables has two primary keys? (a) BOOKS (b) PUBLISHING COMPANY (c) DEPARTMENT (d) none of the above

Explanation / Answer

1)Employee table has the composite attribute

Employee_Firstname

Employee_lastname

2)A book can be published by only one company

since it is one to one it is week

3)None of these

It does not have any multi valued attribute since multivalued attribute is the variable that stores more than one value

4)PUBLISHING_COMPANY

The publishing company does not has any reference or Foreign key it just has the single primary key

5)DEPARTMENT

Since department has Dept ID and Manager ID

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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