ERD / Data Model Notes (Project 1 - DAB Enterprise Ltd)

Entities:
1) Product
- productName (PK)
- category
- quantity (Stored Quantity)
- unitPrice
- totalPrice

2) Sales
- saleId (PK)
- productName (FK -> Product.productName)
- soldQuantity
- soldUnitPrice
- soldTotalPrice
- salesDate

3) StockStatus
- Remaining quantities are derived from Product + Sales.
- RemainingQuantity = quantity - SUM(soldQuantity) for the selected day (or total).
- If an implementation requires persistence, create a stock_status collection with:
  - stockDate
  - productName (FK)
  - availableQuantity
  - soldQuantity
  - remainingQuantity

Cardinality:
- Product (1) ---- (many) Sales
- Sales relate to exactly one Product per sale record.
- StockStatus report is computed (effectively 1 Product can have many sales entries contributing to its daily remaining).

