Designing Shopping cart ERD


shopping cart
image credit:wikipedia.org

Designing Shopping cart ERD

While designing Shopping cart ERD , we have to look for the common functions that are performed such as

* user’s arrival to the website
* user is registering to the site
* user searches for a product
* user placing an order
* user checks out
* user cancelling the order.
A shopping cart is a software that performs ordering and cancelling of orders in easier terms.
The shopping cart is a form of content management system that has e-commerce functionality.
The security of this software depends upon:

* Routinely backups
* All data backups
* Failover/cluster hardware firewalls

One of the first shopping carts was introduced on June 4, 1937, the invention of Sylvan Goldman, owner of the Piggly Wiggly supermarket chain in Oklahoma City (another shopping-cart innovator was Orla Watson, who invented the swinging rear door to allow for “nesting” in 1946).

reference:wikipedia

Types—-

1.Open source (free or paid)
2.Hosted
3. CMS

The ERD diagram using Chen’s Notation—–

ERD

If we classify the attributes then, they will be:

attrib

Similarly, other entities have attributes like these:

Order——

ID,Date,Item,Quantity

Website——-

e-commerce
scripting language php
single sign on

History—-

The development of web shop systems took place right after the Internet became a mass medium. This was a result of the launch of the browser Mosaic in 1993 and Netscape in 1994. It created an environment in which web shops were possible. The Internet therefore acted as the key infrastructure developments that contributed to the rapid diffusion of the e-commerce, a subset of e-business that describes all computer-aided business transactions. In 1998 a total of 11 e-business models were observed, one of which was the e-shop business model for a B2C (business-to-consumer) business—also called the “online shop” The two terms “online shop” and “electronic” or “e-shop” are used interchangeably. The term “online shopping” was invented much earlier in 1984; for example TV shopping often used the term before the popularity of the online method. Today the term primarily refers to the B2C transactional business model. In order to enable “online shopping” a software system is needed. Since “online shopping”, in the context of the B2C business model, became broadly available to the end consumer, internet-based “online shops” evolved.

For online shopping systems in this context the narrower term “web shop” is used. No term has become solidly established for a B2C e-commerce software system. Whereas in the German-speaking region terms such as “web shop software” or “online shop software” are used, the term “shopping cart software” has become established in the United States

reference:https://en.wikipedia.org/wiki/Shopping_cart_software

Syed Adeel Ahmed
Analyst, Programmer, Educationist and Blogger at Technofranchise
Computer Systems Engineer from Sir Syed University Of Engineering & Technology.I am passionate about all types of programming.
Syed Adeel Ahmed on FacebookSyed Adeel Ahmed on GoogleSyed Adeel Ahmed on InstagramSyed Adeel Ahmed on Twitter

Published by

Syed Adeel Ahmed

Computer Systems Engineer from Sir Syed University Of Engineering & Technology.I am passionate about all types of programming.