Question: Using MySQL Create an ER model for the following (see below). Make reasonable assumptions if you feel that some information is missing but clearly state

Using MySQL Create an ER model for the following (see below). Make reasonable assumptions if you feel that some information is missing but clearly state them. Use the MySQL Workbench to create the model then forward engineer it into a set of relations. Make sure that the model notation is Crow's Foot (in MySQL Workbench ensure that your selection is Model -> Relationship Notation ->Crow's Foot (IE)). Describe your assumptions (simply and briefly stated) and then present your model (including screenshots from Workbench) and your DB. For your DB, first show all tables (using a screenshot) without their details and then for each one list the details in terms of attributes and keys. Your identifying (key) attributes in your model and the primary keys in your tables must be such that their names end with '22' (e.g.: a Department has an attribute 'employeenumber' which is a primary key. Employee numbers would have to end in '22'. e.g.: 135919022. 1035100022. 99922. etc. Create at least 3 random values for each attribute and recall that primary key values have to end with '22 Include the auto-generated script from the Forward Engineering function as a part of your answer Specifications Information about a company and its divisions, departments, and employees A department employs many employees and an employee may be employed by a number of departments. If an employee works for more than one department, the percentage of salary covered by each department must be recorded. . Some employees, known as "rovers," are not assigned to any department. A division operates many departments, but each department is operated by only one division. An employee may be assigned to many projects, and a project may have many employees assigned to it. A project must have at least one employee assigned to it. Each department is managed by an employee and no employee may manage more than one department. A department manager gets a yearly bonus and is also assigned a company vehicle A division has a director, while an employee may not be a director of more than one division. A director receives company stock based on performance as determined by the company's board. For simplicity, you should model the performance and stock as a simple attribute each Minimal information kept on: o Employees: employee number, first and last names, and a phone number o Department: department number, name, phone number o Division: division number o Vehicle: serial number, registration plate, model, make, year , name, phone number
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
