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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!