Question: i need help with making a ER diagram for my company I chose leaf filter , based on the requirements (business rules) ER Diagram for
i need help with making a ER diagram for my company I chose leaf filter , based on the requirements (business rules)
ER Diagram for Leaf Filter:
- Customer (Attributes: customer_id, name, address, contact_details)
- Order (Attributes: order_id, order_date, customer_id)
- Product (Attributes: product_id, product_name, category_id)
- Category (Attributes: category_id, category_name)
- InstallationService (Attributes: service_id, order_id, technician_id, status)
- Location (Attributes: location_id, customer_id, address)
- Technician (Attributes: technician_id, technician_name)
- Supplier (Attributes: supplier_id, supplier_name)
- Inventory (Attributes: product_id, supplier_id, quantity)
Relationships:
- Customer-Order: One-to-Many (A customer can have multiple orders, but an order belongs to only one customer)
- Order-Product: Many-to-Many (An order can have multiple products, and a product can be part of multiple orders)
- Product-Category: One-to-Many (A product belongs to one category, but a category can have multiple products)
- Order-InstallationService: One-to-One (An order has one installation service, and an installation service belongs to one order)
- Customer-Location: One-to-Many (A customer can have multiple locations, but a location belongs to only one customer)
- InstallationService-Technician: Many-to-Many (An installation service can have multiple technicians, and a technician can be assigned to multiple installation services)
- Product-Supplier: Many-to-Many (A product can be supplied by multiple suppliers, and a supplier can supply multiple products)
- Product-Inventory: One-to-One (A product has one inventory entry, and an inventory entry corresponds to one product)
Relational Schema for Leaf Filter:
Customer (customer_id, name, address, contact_details) Order (order_id, order_date, customer_id) Product (product_id, product_name, category_id) Category (category_id, category_name) InstallationService (service_id, order_id, technician_id, status) Location (location_id, customer_id, address) Technician (technician_id, technician_name) Supplier (supplier_id, supplier_name) Inventory (product_id, supplier_id, quantity)
Note: Primary keys are denoted by underlining the attribute, and foreign keys are specified as references to the primary key of the corresponding table.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
