Online Shop Data Model
This is a data model for a webshop. The webshop supports products with multiple images, product reviews, and product specials (such as this week 30% discount). Customers put the product(s) they want to buy/order in a basket.
Click on the image to enlarge
Notation: Crow's Foot
IDEF1X Notation | Crow's Foot Notation
Entities in this data model:
Address ,Basket ,BasketProducts ,BasketStatus ,Category ,CategoryProduct ,City ,Country ,Customer ,Manufacturer ,Order ,OrderedProduct ,OrderStatus ,Product ,ProductImage ,ProductSpecial ,Review ,StateOrProvince ,TaxClass ,TaxRate ,ZipCode
Download This Data Model
The download is a zipfile containing .dez files (the data model), images of the data model, and a license agreement. The .dez file contains a data model with MS SQL Server 2005 as target database. You can easily switch the target database to another database (MS Access, MySQL, Oracle, PostgreSQL,...) in DeZign for Databases.
You must use DeZign for Databases to open/view/edit the data model(s) (.dez file).
Please read the license before downloading this data model.