Scribd Logo
Upload

Welcome to Scribd!

  • 35 views

    Ass 2

    Uploaded by

    sp22-bse-097
    This document contains entity relationship diagrams (ERDs) for a boutique management system. The ERDs show the relationships between customers, products, orders, sales, couriers and employees. Key entities include OnlineCustomer, Products, OnlineOrder, Sales, CourierCompany and Employee. Attributes include names, dates, prices and other details to track customers, inventory, purchases and staff.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Ass 2

    Uploaded by

    sp22-bse-097
    35 views3 pages
    This document contains entity relationship diagrams (ERDs) for a boutique management system. The ERDs show the relationships between customers, products, orders, sales, couriers and employees. Key entities include OnlineCustomer, Products, OnlineOrder, Sales, CourierCompany and Employee. Attributes include names, dates, prices and other details to track customers, inventory, purchases and staff.

    Original Description:

    Boutique management system

    Original Title

    ass2

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains entity relationship diagrams (ERDs) for a boutique management system. The ERDs show the relationships between customers, products, orders, sales, couriers and employees. Key entities include OnlineCustomer, Products, OnlineOrder, Sales, CourierCompany and Employee. Attributes include names, dates, prices and other details to track customers, inventory, purchases and staff.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    35 views3 pages

    Ass 2

    Uploaded by

    sp22-bse-097
    This document contains entity relationship diagrams (ERDs) for a boutique management system. The ERDs show the relationships between customers, products, orders, sales, couriers and employees. Key entities include OnlineCustomer, Products, OnlineOrder, Sales, CourierCompany and Employee. Attributes include names, dates, prices and other details to track customers, inventory, purchases and staff.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 3

    BOUTIQUE MANAGEMENT SYSTEM

    ASSIGNMENT 2
    SQL ERD:
    OnlineCustomer
    CustomerID

    Username
    Customer
    Password CustomerID

    Name

    Gender

    DateOfBirth
    Products ContactNumber
    productId
    Email
    name
    RegistrationDate
    size
    PurchaseHistory
    color
    Address
    OnlineOrder material
    CustomerStatus
    OrderID category
    CustomerID

    OrderDate

    ProductID

    qty
    Sales
    sale_price
    purchase SaleID
    DeliveryStatus purchaseID ProductID
    CourierID productId Quantity
    EmployeeID date_of_purchase sale_price
    purchase_price SaleDate
    quantity CustomerID
    qty_rem EmployeeID
    supplier

    CourierCompany
    CourierID

    CompanyName

    ContactInformation
    Employee
    DeliveryTimeEstimates EmployeeID
    Price
    PriceID Name

    ProductID Gender

    purchase_price DateOfBirth

    sale_price ContactNumber

    Email

    Position

    Salary

    HireDate

    Address
    ENCHANCED ERD:

    You might also like