TOPIC: Collect a simple ER diagram with explanation

                              BOOK STOCK MANAGEMENT SYSTEM

ER diagram of a book stock management system is given below. Books are written by authors & 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 consists of address, URL.
  • Book is uniquely identified by ISBN. It also consists of year, title and price.
  • Publisher is uniquely identified by Name. It also consists of Address, Phone and URL.
  • Customer is uniquely identified by email. It also consists of Name, address, phone.
  • Shopping basket is uniquely identified by basket id.
  • Ware house is uniquely identified by code. It also consist of address, phone.

Many author writes many books.

A publisher can publish many books.

Many books can be stocked in a warehouse.

A customer can have many shopping baskets.

A shopping basket contains many books.

ANSWER

STEP-1 :-> IDENTIFYING THE ENTITIES

The entities are

  • AUTHOR
  • BOOK
  • PUBLISHER
  • WAREHOUSE
  • SHOPPING-BASKET
  • CUSTOMER

STEP-2 :-> IDENTIFYING THE RELATIONSHIPS

 

Many author writes many books.M:N CARDINALITY

A publisher can publish many books.N:1 CARDINALITY

Many books can be stocked in a warehouse.N:1 CARDINALITY

A customer can have many shopping baskets.1:N CARDINALITY

A shopping basket contains many books.1:N CARDINALITY

STEP-3 :-> IDENTIFYING KEY ATTRIBUTES

AUTHOR NAME

BOOK ISBN

PUBLISHER NAME

WAREHOUSE CODE

SHOPPING-BASKET BASKETID

CUSTOMER EMAIL

 

STEP-4 :-> OTHER RELEVANT ATTRIBUTES

AUTHOR URL, ADDRESS

BOOK YEAR, TITLE, PRICE

PUBLISHER ADDRESS, PHONE, URL

WAREHOUSE ADDRESS, PHONE

CUSTOMER NAME, ADDRESS, PHONE

 

 

 

STEP-5 :-> ER DIAGRAM

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Advertisements