Question

Think about four main activities that your database should support:

Searching books by authors, or authors by books.

Tracking the current stock of books (hint: needs only one additional attribute).

Ordering books from suppliers (by phone or mail).

Keep a catalog of customers, including delivery addresses.

No need to map books to customers. That means that the customer info doesn't connect with the book/supplier tables. Your solution should have either 4 or 5 entities.

A diagram that includes:

An ER diagram

Relational Vocabulary

Sketch of relational tables

Answer 1