Use MySQL Workbench to answer the following. Provide screenshots mainly. Copied answers will be flagged
1. Use the MySQL Workbench to create an ER model with the specifications below. Make reasonable assumptions and adjustments to fit the specifications as much as possible but be sure to state and describe these. After, use the Forward Engineering function for the model into a set of relations (Crow's foot notation). Finally, include screenshots from the workbench and the database. Show all tables (using a screenshot) without their details and then for each one list the details in terms of attributes and keys Z 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. 3 Create at least 3 random values for each attribute and recall that primary key values have to end with '22 4 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 o o o Employees: employee number, first and last names, and a phone number Department: department number, name, phone number Division: division number, name, phone number Vehicle: serial number, registration plate, model, make, year 1. Use the MySQL Workbench to create an ER model with the specifications below. Make reasonable assumptions and adjustments to fit the specifications as much as possible but be sure to state and describe these. After, use the Forward Engineering function for the model into a set of relations (Crow's foot notation). Finally, include screenshots from the workbench and the database. Show all tables (using a screenshot) without their details and then for each one list the details in terms of attributes and keys Z 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. 3 Create at least 3 random values for each attribute and recall that primary key values have to end with '22 4 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 o o o Employees: employee number, first and last names, and a phone number Department: department number, name, phone number Division: division number, name, phone number Vehicle: serial number, registration plate, model, make, year
