[go: up one dir, main page]
Scribd
Upload
65 views1 page

Author Publisher: Address Address Phone

The document describes an ERP model for an online book store that processes book records, customer records, shopping basket records, shopping basket updates, and bill records. It generates reports for all books, customers, orders, shopping basket updates, and bills. The model structures the database using normalization to reduce redundancy and improve data integrity, as proposed by Edgar Codd in the relational model.

Uploaded by

Jazzy JS
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
65 views1 page

Author Publisher: Address Address Phone

The document describes an ERP model for an online book store that processes book records, customer records, shopping basket records, shopping basket updates, and bill records. It generates reports for all books, customers, orders, shopping basket updates, and bills. The model structures the database using normalization to reduce redundancy and improve data integrity, as proposed by Edgar Codd in the relational model.

Uploaded by

Jazzy JS
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Topic- ERP model for Online Book Store

Address
Address Name Phone
Name

URL URL
Author
Publisher

Addres
s
Email

Written-By Published-By Name Phone

Customer
Year

Books
Title Basket
Number ID
Basket-of

Pric
e

ISBN Contains Shopping-basket


Final
Order

Stock
Warehouse Code
s
Bill

Phone
Number Address

Database normalization is the process of structuring a database, usually a relational database, in


accordance with a series of so-called normal forms in order to reduce data redundancy and improve data
integrity. It was first proposed by Edgar F. Codd as part of his relational model.

The model describes,

• Processing Book records and generate report of all Book.

• Processing Customer records and generate report of all Customer.

• Processing shopping basket records and generate report of all Order.

• Processing shopping basket update records and generate report of all shopping basket update.

• Processing Bills records and generate report of all Bills.

You might also like