TechCo is a technology company that specializes in manufacturing and selling electronic products. As part of our efforts to streamline operations and enhance data management, we are embarking on the development of a comprehensive database system. This system will be designed to support various aspects of our business, including departments, employees, customers, suppliers, products, sales orders and payments.

Create the ERD with entity name and attributes for each entity in 3NF. Include in model:

Primary Key

Foreign Key

Crow foot notation

Summary of business requirements:

1. Department TechCo has multiple departments that operate in different locations. Each department has a unique identifier (DepartmentID), a name, and a location.

2.

Employee Within each department, employees play a crucial role. Each employee is identified by an EmployeeID and possesses personal details such as first name, last name, email, phone number, and salary. They are also associated with the department they work in.

3. Customer

Our customers are vital to our business. Each customer has a uniqueCustomerID and provides us with their personal information, including first name, last name, email address, and phone number. Customers place orders and make payments.

4. Supplier

Our suppliers are essential partners. Each supplier is identified by a SupplierID and provides us with company information, including the company name, contact name, email address, and phone number. Suppliers are responsible for delivering the products we sell.

5. Product

Our products are diverse and make up our core offerings. Each product has aProductID, a name, a detailed description, a price, and information about its stock quantity. Products are categorized into various product categories.

6. Product Category

Products are organized into distinct categories. Each category has a uniqueCategoryID and a name. Products belong to one product category.

7. Sales Order

Customer orders are tracked through sales orders. Each sales order is assigned anOrderID, records the order date, and calculates the total order amount. Sales orders contain multiple order lines.

8. Order Line

Each sales order comprises several order lines, each representing a product and its quantity. Order lines have unique identifiers (OrderLineID) and store information about the quantity and line total. Each order line includes one product.

9. Payment

Customers make payments for their orders. Each payment is identified by aPaymentID, includes a payment date, and specifies the payment amount. Payments are made by customers