Scribd
Upload
38 views3 pages

Categories

The document outlines a database schema consisting of various entities such as Categories, Products, Suppliers, Employees, Customers, and Orders, each with defined attributes and relationships. Key entities include Products linked to Categories and Suppliers, Customers linked to Orders and Feedback, and Employees with a self-referencing supervisor relationship. Additionally, it includes entities for managing Payments, Promotions, Advertisements, Carts, Services, Shipping, and Loyalty Points.

Uploaded by

luongdz10vnvt
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
38 views3 pages

Categories

The document outlines a database schema consisting of various entities such as Categories, Products, Suppliers, Employees, Customers, and Orders, each with defined attributes and relationships. Key entities include Products linked to Categories and Suppliers, Customers linked to Orders and Feedback, and Employees with a self-referencing supervisor relationship. Additionally, it includes entities for managing Payments, Promotions, Advertisements, Carts, Services, Shipping, and Loyalty Points.

Uploaded by

luongdz10vnvt
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/ 3

 Categories

 CategoryID (PK)

 CategoryName

 Description

 Products

 ProductID (PK)

 ProductName

 CategoryID (FK)

 SupplierID (FK)

 Price

 StockID (FK)

 PromotionID (FK)

 Description

 Suppliers

 SupplierID (PK)

 SupplierName

 ContactInfo

 Address

 Stock

 StockID (PK)

 Quantity

 ProductID (FK)

 WarehouseLocation

 Employees

 EmployeeID (PK)

 EmployeeName

 SupervisorID (FK) – for self-referencing (supervisor-employee)

 JobTitle

 ContactInfo

 Customers

 CustomerID (PK)
 CustomerName

 ContactInfo

 FeedbackID (FK)

 Feedback

 FeedbackID (PK)

 CustomerID (FK)

 Rating

 Comments

 Orders

 OrderID (PK)

 CustomerID (FK)

 OrderDate

 TotalAmount

 PaymentID (FK)

 ShipperID (FK)

 Invoices

 InvoiceID (PK)

 OrderID (FK)

 PaymentID (FK)

 PaymentDate

 AmountPaid

 Payments

 PaymentID (PK)

 PaymentType

 PaymentStatus

 Promotions

 PromotionID (PK)

 PromotionName

 DiscountRate

 StartDate

 EndDate
 Advertisements

 AdID (PK)

 PromotionID (FK)

 AdContent

 StartDate

 EndDate

 Carts

 CartID (PK)

 CustomerID (FK)

 ProductID (FK)

 Quantity

 Services (Consultation)

 ServiceID (PK)

 ServiceType

 EmployeeID (FK) – for consultation services

 CustomerID (FK)

 Shipping

 ShipperID (PK)

 ShipperName

 ContactInfo

 ShippingStatus

 LoyaltyPoints

 LoyaltyID (PK)

 CustomerID (FK)

 PointsEarned

 PointsRedeemed

You might also like