1. Which of the following tables has a composite attribute? 2. Relationship betw

Question

1. Which of the following tables has a composite attribute? 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. 5. Which of the following tables has two primary keys? 6. Are EMPLOYEE and DEPARTMENT tables union compatible? ? (a) yes (b) no 7. Can the inner ioin operation be performed on BOOK S and BOOK PRICES tables? (a) yes (b) no 8. Which of the following functional dependence is valid? If all are valid, select d. If all are not valid select e. (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 ()PUBLISHING COMPANY (d) all have foreign keys (a) BOOKS (b) PUBLISHING COMPANY (c) DEPARTMENT (d) none of the above (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 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. () none of the above

Explanation / Answer

1. d. none of the above.
Because composite means it is a combination of two. Here there are no combined attribute.

2. c. Identifying
Because publishing company will have books information in its table.

3. d.None of the above
Each one holds only single value

4. d. all have foreign keys
Because each table needs to store book id from books table.

5. c. Department
It constains the book id and its department id as primary keys.

6. a. Yes
We can do union based of the department no column on both the tables.

7. a. Yes

8. a and d

9. No
There is no relation between these two tables.

10. b.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

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