Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help me with this MySQL databases question. For each of the following questions create an ER model. If you feel that some information is
please help me with this MySQL databases question.
For each of the following questions create an ER model. If you feel that some information is lacking, then make reasonable assumptions, but state them clearly at the beginning of your answer. Use the MySQL Workbench to create the model and 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 the last two digits ofyour student ID 1. 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: e o Employees: employee number, first and last names, and a phone number o Department: department number, name, phone number o Division: division number, name, phone number Activate Wi de Vehicle: serial number. registration olate. model. make. vearStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started