hits A end fn Q1 In HAVAC company, the following employee information is stored: Employee ID, First and Last name, Rank, and billing rate. Employees are organized into specialties, each specialty has a master of that specialty, who is coordinating the assignment of all employees in that specialty to the projects. For each specialty, we record the specialty ID and name. An employee can belong to only one specialty. The scheduling system also stores information about project. For each project, the following information is stored: Project ID, Status, Location. More than one employee can be assigned into the project. When an assignment is requested for an employee, the employee is scheduled to work on a particular project, for the specified amount of his full available time (10%- 100%). So, one employee can be assigned in multiple projects. EON BAPHICS Q2 Automata Inc. produces specialty vehicles by contract. The company operates several departments, each of which builds a particular vehicle, such as a limousine, a truck, a van, or an RV. Before a new vehicle is built, the department places an order with the purchasing department to request specific components. Automata's purchasing department is interested in creating a database to keep track of orders and to accelerate the process of delivering materials. The order received by the purchasing department may contain several different items. An inventory is maintained so that the most frequently requested items are delivered almost immediately. When an order comes in, it is checked to determine whether the requested item is in inventory. If an item is not in inventory, it must be ordered from a supplier. Each item may have several suppliers. February 17, Monday Conceptual Data Modeling - 50 points Create a data model (ERD) based on the following business rules. You must Identify all of the main entities. Identify all of the relations and connectivities. Identify PK and FK Identify the type of participation optionality, existence dependency and relationship strength in all the relationships. Resolve the many to many relationships using the associative entities. Identify subordinate relationships (super type vs. sub type). You must use Lucidchart to draw the ERD (and then copy and paste your complete diagram into hits A end fn Q1 In HAVAC company, the following employee information is stored: Employee ID, First and Last name, Rank, and billing rate. Employees are organized into specialties, each specialty has a master of that specialty, who is coordinating the assignment of all employees in that specialty to the projects. For each specialty, we record the specialty ID and name. An employee can belong to only one specialty. The scheduling system also stores information about project. For each project, the following information is stored: Project ID, Status, Location. More than one employee can be assigned into the project. When an assignment is requested for an employee, the employee is scheduled to work on a particular project, for the specified amount of his full available time (10%- 100%). So, one employee can be assigned in multiple projects. EON BAPHICS Q2 Automata Inc. produces specialty vehicles by contract. The company operates several departments, each of which builds a particular vehicle, such as a limousine, a truck, a van, or an RV. Before a new vehicle is built, the department places an order with the purchasing department to request specific components. Automata's purchasing department is interested in creating a database to keep track of orders and to accelerate the process of delivering materials. The order received by the purchasing department may contain several different items. An inventory is maintained so that the most frequently requested items are delivered almost immediately. When an order comes in, it is checked to determine whether the requested item is in inventory. If an item is not in inventory, it must be ordered from a supplier. Each item may have several suppliers. February 17, Monday Conceptual Data Modeling - 50 points Create a data model (ERD) based on the following business rules. You must Identify all of the main entities. Identify all of the relations and connectivities. Identify PK and FK Identify the type of participation optionality, existence dependency and relationship strength in all the relationships. Resolve the many to many relationships using the associative entities. Identify subordinate relationships (super type vs. sub type). You must use Lucidchart to draw the ERD (and then copy and paste your complete diagram into