Kuliah - Data Warehouse - Data Warehouse

@startuml "Database Design"

entity "employees" {}

entity "customers" {}

entity "suppliers" {}

entity "stores" {}

entity "clothes" {}

entity "sales_transactions" {
    employee_id : int <<fk>>
    supplier_id : int <<fk>>
    clothes_id : int <<fk>>
    --
    date : date
    unit_price : decimal
    quantity : int
}

entity "purchase_transactions" {
    employee_id : int <<fk>>
    supplier_id : int <<fk>>
    clothes_id : int <<fk>>
    --
    date : date
    unit_price : decimal
    quantity : int
}

entity "rental_transactions" {
    employee_id : int <<fk>>
    supplier_id : int <<fk>>
    clothes_id : int <<fk>>
    --
    date : date
    unit_price : decimal
    quantity : int
}

stores --o{ employees
stores --o{ clothes

employees --o{ purchase_transactions
customers --o{ purchase_transactions
clothes --o{ purchase_transactions

employees --o{ sales_transactions
suppliers --o{ sales_transactions
clothes --o{ sales_transactions

employees --o{ rental_transactions
customers --o{ rental_transactions
clothes --o{ rental_transactions

@enduml