In Chapter 8, we described a database with two entities, COURSE and INSTRUCTOR. Book was left as

Question:

In Chapter 8, we described a database with two entities, COURSE and INSTRUCTOR. “Book” was left as an attribute of COURSE. Extend the database to include book as an entity. Attributes of book might include book title, author, price, edition, and publisher. Explore the relationships that might exist here: use “in” or “by,” “write,” “teach,” and so on. Draw an ER diagram with at least two relationships, one of them ternary. What would be some attributes of the relationships?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database Design Using Entity Relationship Diagrams

ISBN: 9781032017181

3rd Edition

Authors: Sikha Saha Bagui, Richard Walsh Earp

Question Posted: