Database System

An online bookstore asks you to design a database to keep track of customer transaction. The rules are

A customer can buy many books

A book can be bought by many customers

Some Customers do not buy any book.

Some book is never bought.

List existence-dependent entity________________________

List existence-independent entity________________________

Please design a database model (using Crows foot notation) for this online bookstore.

(Assume that CUSTOMER has the following attribute: CUS_NUM, CUS_NAME,

BOOK has the following attribute: BOOK_CODE, BOOK_COPY , BOOK_TITLE, ISBN)

CUSTOMER (CUS_NUM, CUS_NAME, CUS_EMAIL)

BOOK(BOOK_CODE, BOOK_COPY , BOOK_TITLE, ISBN)