"Selling on Amazon" Project
Welcome to the "Selling on Amazon" project! This project is part of a course where I had the opportunity to design, implement, and utilize my own database, all within a single term. The main goal of this project was to create a fully functional database that supports the selling process on Amazon. Through this project, I gained hands-on experience in database design, implementation, and testing, while also understanding the core data, requirements, and use cases specific to the "Selling on Amazon" domain.
Structural business rules are a useful tool to frame and guide your design; they indicate the entities, relationships, optionalities, and pluralities of any Project design.
Entities that are critical to the design of this project are
• Seller • Customers • Products • Product Category • Inventory • Orders • Package/Shipment • Speed • Notifications
Structural Business Rules
-
A Customer can Order one or more Products
-
A Customer can create one and one account under one username.
-
Every Order must be placed by only one Customer.
-
A Product can be ordered one or more times.
-
A Product can never be ordered by any of the Customers.
-
A Product belongs to one and one Product Category.
-
A Product Category can have multiple Products associated with it.
-
A Seller can sell multiple Products.
-
Each Package must be delivered by one Seller only.
-
An Order can have one or more Products.
-
All the Products should be listed in the Inventory.
-
An inventory can have one or more Products.
-
The number of Products should be updated every time a new product is added by the Seller, or any Products is Ordered by any Customer.
-
Every Package should be notified to the Customer.
-
A Seller can create a new listing or reuse the already existing Product listing.
Conceptual ER Diagram
Logical ER Diagram
