3. As a requirements engineer, you have been charged with designing a relational database to support the operation of an aircraft systems firm's new automated manufacturing system. Parts in the automated manufacturing system are processed in batches. A batch consists of the part types and quantities specified by a set of orders sent down from sales. Each order is for a particular customer, and is for a certain quantity of items of a single part type. Each part type requires multiple machines in the automated manufacturing system for processing. Each machine in the automated manufacturing system may be needed for several different part types, or for none at all. Further investigation of automated manufacturing system operations reveals the following additional information: Each batch is identified by a batch number, and can consist of at most five orders. Each order has a unique order number, a due date, and is processed via a single batch The name and telephone number for each customer is known (some customers are known to have the same name). A customer can only have one open order at any given time. Each part type has a name, a unique identification number, and requires up to six different machines for processing. The same part type could appear on multiple orders at the same time. Each machine in the automated manufacturing system has a different number assigned to it, and a utilization code indicating the desired utilization level. Develop an E-R model for this scenario. Your model should consist of the following: a) A list of entities and attributes, with primary keys indicated. b) A description of the relationships, and specification of type of each relationship between orders and each of batches, customers and part types, and between part types and machines. c) An initial E-R diagram, including cardinality and mandatory/optional relationship s