ERD Exercise BIS 422 - Database Management Systems William's Furniture has hired you as a consultant to design a database to manage their materials inventory and customer orders. Before designing the database you conduct a preliminary analysis to identify the entities, relationships, and business rules relevant to William's. Use the following analysis to create an ERD: Department Each department has a DepartmentNbr, Name, and Supervisor. Employee Each employee has an EmployeeNbr, Name, Title, DateofHire, YearsofService, HourlyRate, and Skill(s). Customer Each customer has a CustomerNbr, Name, Address, ContactName, and Contact PhoneNbr. Order Each order has an OrderNbr and OrderDate. Product Each product has a ProductNbr, ProductName, Description, and UnitPrice. Vendor Each vendor has a VendorNbr, Name, Address, ContactName, and ContactPhoneNbr. Raw Material Each raw material has a Materialid, Name, UnitOfMeasure, and UnitCost. Additional Business Rules Customers make zero or many orders. An order belongs to one and only one customer. Employees process many orders. An order is processed by one employee. A department has one or more employees. Each employee works for only one department. An order includes one or more products. Products can appear on many orders. The database must record the Quantity of each product on an order. A product is composed of many raw materials. Raw materials are used in many products. The database must record the Quantity of each raw material used in a product. Vendors supply raw materials to departments. The database must record the Price charged for the supplied raw material and the SupplyDate