using the design file in the image attached to the question :Normalize the database in the design fileBe aware of the possibility of duplicate data.Name in Role and Employee and Emp_Contact_name all refer to the same data.Name and Email in Vendor refer to the Vendor.Assumptions made:An employee works with one or more vendors.An employee may have none or many dependents.An employee may have many roles over the employee's work history and a record should be retained for each role. MySQL WorkbenchMySQL Model (employee (3).mwb) x EER Diagram xEdit View Arrange Model Database Tools ScriptingFileDiagram ********MD+ G1:11:n1:11:nn:mMinAEmployeeEmployeeID VARCHAR(45)Name VARCHAR(45)Email VARCHAR(45)Dependent1 VARCHAR(45)Dependent2 VARCHAR(45)Dependent3 VARCHAR(45)IndexesHelpRoleName VARCHAR(45)Email VARCHAR(45)RoleName VARCHAR(45)StartDate DATETIMEEndDate DATETIME23VendorName VARCHAR(45)Emp_Contact_Name VARCHAR(45)Emp_Contact_Email VARCHAR(45)>Email VARCHAR(45)|IModeling Additions weMWBMWBMWBItimestampscreate_time, update_timeuserusername, email, password, create_...categorycategory_id, nameX8:37 AM

Answered: using the design file in the image…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

using the design file in the image attached to the question :

Normalize the database in the design file

Be aware of the possibility of duplicate data.
Name in Role and Employee and Emp_Contact_name all refer to the same data.
Name and Email in Vendor refer to the Vendor.
Assumptions made:
1. An employee works with one or more vendors.
2. An employee may have none or many dependents.
3. An employee may have many roles over the employee's work history and a record should be retained for each role.

MySQL Workbench
MySQL Model (employee (3).mwb) x EER Diagram x
Edit View Arrange Model Database Tools Scripting
File
Diagram ********
M
D
+ G
1:1
1:n
1:1
1:n
n:m
Min
A
Employee
EmployeeID VARCHAR(45)
Name VARCHAR(45)
Email VARCHAR(45)
Dependent1 VARCHAR(45)
Dependent2 VARCHAR(45)
Dependent3 VARCHAR(45)
Indexes
Help
Role
Name VARCHAR(45)
Email VARCHAR(45)
RoleName VARCHAR(45)
StartDate DATETIME
EndDate DATETIME
2
3
Vendor
Name VARCHAR(45)
Emp_Contact_Name VARCHAR(45)
Emp_Contact_Email VARCHAR(45)
>Email VARCHAR(45)
|
I
Modeling Additions we
MWB
MWB
MWB
I
timestamps
create_time, update_time
user
username, email, password, create_...
category
category_id, name
X
8:37 AM

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 6 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions