TOPIC : BOOK STOCK MANAGEMENT SYSTEM

 

 

Question:

 

ER Diagram of a BOOK STOCK MANAGEMENT SYSTEM is given below.Books are written by authors and published by the publishers.Shopping basket contains books.Ware house stocks books.Customer takes book from shopping basket.

 

 

Author is uniquely identified by Name.It also consist of address,URL

Book is uniquely identified by ISBN.It also consist of year,title,price

Publisher is uniquely identified by Name.It also consist of Address,Phone,URL

Customer is uniquely identified by email.It also consist of Name,Address,phone

Shopping basket is uniquely identified by basketID

Ware house is uniquely identified by code.It also consist of Address,phone.

ER DIAGRAM

RELATIONAL MODEL

 

 

Advertisements