Scribd Logo
Upload

Welcome to Scribd!

  • 37 views

    Database ER Diagram (Crow's Foot)

    Uploaded by

    Farisnazmi
    The document describes an entity relationship diagram with multiple entities and relationships. The diagram shows entities like supplier, customer, item, staff and categories. It also shows primary and foreign keys between the different entities.

    Copyright:

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

    Database ER Diagram (Crow's Foot)

    Uploaded by

    Farisnazmi
    37 views1 page
    The document describes an entity relationship diagram with multiple entities and relationships. The diagram shows entities like supplier, customer, item, staff and categories. It also shows primary and foreign keys between the different entities.

    Original Title

    Database ER diagram (crow's foot) (1)

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes an entity relationship diagram with multiple entities and relationships. The diagram shows entities like supplier, customer, item, staff and categories. It also shows primary and foreign keys between the different entities.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    37 views1 page

    Database ER Diagram (Crow's Foot)

    Uploaded by

    Farisnazmi
    The document describes an entity relationship diagram with multiple entities and relationships. The diagram shows entities like supplier, customer, item, staff and categories. It also shows primary and foreign keys between the different entities.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    SUPPLY SUPPLIER MANAGER

    PK/FK PK SupllierID PK M_ID


    ItemID
    1
    Address M_PhoneNO
    PK/FK
    SupplierID S_ContactNo M_Name
    2
    able M_Add

    for manage

    CUSTOMER ITEM ACCESS STAFF


    PK CustID PK ItemID PK/FK PK StaffID
    CategoryID
    CustName ItemName 1
    StaffName
    CustEmail Exp_Date PK/FK
    ItemID StaffEmail
    2
    CustNO Manc_Date StaffNo
    buy listed PK/FK handle
    CustAdd Price StaffID
    3
    CustID

    FK CategoryID FK M_ID

    receive have

    RECEIPT CATEGORY

    PK ReceiptID PK CategoryID
    TotalPrice CategoryName
    Tax

    Key Field Key Field

    You might also like