Team :
- Stefan Liemawan
- Jordy Filbert
- Hand Edbert
We are building a database system management of a dairy product–seling company, under the name “Sirloin Dairy Product”. The database itself consist of 6 tables which is :
- Branch
- branch_id (PK)
- branch_location
- branch_manager
- num_of_staff
- num_of_office
- Product
- product_id (PK)
- branch_id (FK)
- product_name
- product_category
- Pricing
- product_id (FK)
- product_cost
- product_price
- product_gross_profit (product_price – product_cost)
- Staff
- staff_id (PK)
- branch_id (FK)
- staff_name
- staff_age
- staff_gender
- staff_phone
- staff_position
- staff_office
- Customer
- customer_id (PK)
- customer_name
- Transaction
- date
- transaction_id (PK)
- branch_id (FK)
- customer_id (FK)
- product_id (FK
- quantity
