Scribd
Upload
16 views11 pages

R Vijay Hari Haran RV Kamlesh Bharath Kumar S M Arun Senthil Kumar

Uploaded by

Kochappen Ipe Kumar

This document discusses database normalization for an online mobile shopping portal. It begins by introducing the entities in the system - Customer, Shopping Cart and Mobile. It then shows the database in 0NF, 1NF, 2NF and 3NF forms, removing multivalued attributes and dependencies each time. The final normalized database structure separates data into five tables - Customer, Mobile, Order, Payment and Delivery.

Copyright:

Attribution Non-Commercial (BY-NC)
Download as PPTX, PDF, TXT or read online from Scribd
Download as pptx, pdf, or txt

R Vijay Hari Haran RV Kamlesh Bharath Kumar S M Arun Senthil Kumar

Uploaded by

Kochappen Ipe Kumar
16 views11 pages
This document discusses database normalization for an online mobile shopping portal. It begins by introducing the entities in the system - Customer, Shopping Cart and Mobile. It then shows the database in 0NF, 1NF, 2NF and 3NF forms, removing multivalued attributes and dependencies each time. The final normalized database structure separates data into five tables - Customer, Mobile, Order, Payment and Delivery.

Original Title

DBMS

Copyright

© Attribution Non-Commercial (BY-NC)

Available Formats

PPTX, PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

This document discusses database normalization for an online mobile shopping portal. It begins by introducing the entities in the system - Customer, Shopping Cart and Mobile. It then shows the database in 0NF, 1NF, 2NF and 3NF forms, removing multivalued attributes and dependencies each time. The final normalized database structure separates data into five tables - Customer, Mobile, Order, Payment and Delivery.

Copyright:

Attribution Non-Commercial (BY-NC)
Download as PPTX, PDF, TXT or read online from Scribd
Download as pptx, pdf, or txt
16 views11 pages

R Vijay Hari Haran RV Kamlesh Bharath Kumar S M Arun Senthil Kumar

Uploaded by

Kochappen Ipe Kumar
This document discusses database normalization for an online mobile shopping portal. It begins by introducing the entities in the system - Customer, Shopping Cart and Mobile. It then shows the database in 0NF, 1NF, 2NF and 3NF forms, removing multivalued attributes and dependencies each time. The final normalized database structure separates data into five tables - Customer, Mobile, Order, Payment and Delivery.

Copyright:

Attribution Non-Commercial (BY-NC)
Download as PPTX, PDF, TXT or read online from Scribd
Download as pptx, pdf, or txt
You are on page 1/ 11

DBMS

 R VIJAY
 HARI HARAN
 RV KAMLESH
 BHARATH KUMAR
 S M ARUN SENTHIL KUMAR
INTRODUCTION
 India plaza is an on-line portal for buying
mobiles.
ENTITIES
 Customer
 Shopping cart
 Mobile
ATTRIBUTES
 CUSTOMER (customer id, customer Name,
Customer Address)
 MOBILE (Mobile id,mobile description, price)
 SHOPPING CART (OrderNo, Qty, DateOrdered)
0 NF
CUSTOMER ORDER

customer id
Customer Name,
Customer phone number
OrderNo,
Mobile id,
Mobile Description,
Mobile price
Quantity,
Customer Address,
Date Ordered,
Delivery address
1NF -Remove Multivalued Attributes

CUSTOMER SHOPPING CART


Customer id, Customer id,
Customer Name, orderNo,
Customer Address, Mobile no,
Customerr phone Mobile Desc,
number Qty,
DateOrdered
Delivery address
2NF – Remove Partial Dependencies

 CUSTOMER  MOBILE (mobile id,


(customer mobile Desc, price)
id,CustName,
CustAddress)  ORDER (OrderNo,
customer
 SHOPPING CART id,CustName,
(OrderNo, mobile id, payment,delivery
Qty, DateOrdered, address)
total price)
3 NF-Remove Transitive
Dependencies
 CUSTOMER (cust id,  MOBILE (mobile id, mobile
CustName, Desc, mobile price)
CustAddress,  ORDER (OrderNo, cust id,
Customer phone no) CustName, Delivery
address)
 SHOPPING CART  PAYMENT (order no, cust
(OrderNo, mobile id, id, payment mode)
Qty, DateOrdered,
total price)  DELIVERY (delivery
address, order no)
UNDERLYING DATABASE
 CUSTOMER (cust id,  MOBILE (mobile id,
CustName, CustAddress, mobile Desc,
Customer phone no)
mobile price)
 SHOPPING CART
(OrderNo, mobile id,
 ORDER (OrderNo,
Qty, DateOrdered, total cust id, CustName,
price) Delivery address)
 PAYMENT (order no,
cust id, payment mode)
 DELIVERY (delivery
address, order no)
Cust
id
Order
Name
no
customer Address
mode
Phone
payment no
er
buys Order
makes no
Mobile
id
price
quantity Shopping

Mobile * Order
cart

des date
mobiles
Mobile
Total
id
price
Deliv
Added
addr
to
ess
THANK YOU

You might also like