Scribd Logo
Upload

Welcome to Scribd!

  • 25 views

    Er - Diagram Database of Pharmacianidoktorahara: Employee

    Uploaded by

    Pro Kodigo
    This document contains an ER diagram showing the database structure for a pharmacy. The diagram shows 6 entities - Employee, Employee Activity, Order, Payment, Product Details, and Inventory. The Employee entity stores employee data. The other entities track order information, payments, product details, inventory levels and the activities of employees.

    Copyright:

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

    Er - Diagram Database of Pharmacianidoktorahara: Employee

    Uploaded by

    Pro Kodigo
    25 views1 page
    This document contains an ER diagram showing the database structure for a pharmacy. The diagram shows 6 entities - Employee, Employee Activity, Order, Payment, Product Details, and Inventory. The Employee entity stores employee data. The other entities track order information, payments, product details, inventory levels and the activities of employees.

    Original Title

    EMPLOYEE.docx

    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 an ER diagram showing the database structure for a pharmacy. The diagram shows 6 entities - Employee, Employee Activity, Order, Payment, Product Details, and Inventory. The Employee entity stores employee data. The other entities track order information, payments, product details, inventory levels and the activities of employees.

    Copyright:

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

    Er - Diagram Database of Pharmacianidoktorahara: Employee

    Uploaded by

    Pro Kodigo
    This document contains an ER diagram showing the database structure for a pharmacy. The diagram shows 6 entities - Employee, Employee Activity, Order, Payment, Product Details, and Inventory. The Employee entity stores employee data. The other entities track order information, payments, product details, inventory levels and the activities of employees.

    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 1

    ER - Diagram

    Database of PharmaciaNiDoktoraHara
    EMPLOYEE
    Employee ID Employee Name Password Position

    EMPLOYEE ACTIVITY

    Employee ID Position Transaction Date Order_Id

    ORDER

    Customer_name Order_id Order_date Generic_Name Quantity Product Price Discount Amount Due

    PAYMENT

    Employee ID Customer_Name Generic_Name Product_Id Payment_Date Discount Amount_Paid

    PRODUCT DETAILS

    Product_Id Product_Type Generic_Name Brand_Name Product_QuantityIn Product_Price Product_Manufaturer Date_Manufactured Date_Expired

    INVENTORY

    Employee_ID Product_id Product_Quantity Product_QuantityOut

    You might also like