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.Make sure to have a primary key for each table .Make sure to include the relationships between the tables . Bird's Eye ******Zoom: 100% -Catalog Tree ***<mydbTablesViewsRoutine GroupsCatalog Layers User TypesDescription EditorRole: TableReadyDescription Properties H ->Diagram↑NEEB----1:11:n1:11:nn:m1:nEmployeeEmployeeID VARCHAR(45)Name VARCHAR(45)Email VARCHAR(45)Dependent1 VARCHAR(45)Dependent2 VARCHAR(45)Dependent3 VARCHAR(45)Indexes00■0RoleName VARCHAR(45)Email VARCHAR(45)0RoleName VARCHAR(45)StartDate DATETIMEEndDate DATETIMEOHVendor◇Name VARCHAR(45)Emp_Contact_Name VARCHAR(45)Emp_Contact_Email VARCHAR(45)Email VARCHAR(45)Rediangmar SnipA

ANSWER:-Here are the normalized tables:- i. Employee Table: CREATE TABLE Employee (EmployeeID INT(5) PRIMARY KEY NOT NULL,Name VARCHAR(30) NOT NULL,Email VARCHAR(30) NOT NULL); ii. Dependens Table:CREATE TABLE Dependents (EmployeeID INT(5) NOT NULL,Dependent VARCHAR(30) NOT NULL,PRIMARY KEY(EmployeeID,Dependent),CONSTRAINT `f_emp_id` FOREIGN KEY (EmployeeID) REFERENCES Employee (EmployeeID)); iii. Vendor Table:CREATE TABLE Vendor (VendorID INT(5) PRIMARY KEY NOT NULL,EmpID VARCHAR(30) NOT NULL,VendorName VARCHAR(30) NOT NULL,VendorEmail VARCHAR(30) NOT NULL,CONSTRAINT `f_emp_id` FOREIGN KEY (EmpID) REFERENCES Employee (EmployeeID)); iv. Role Table:CREATE TABLE Role (EmpID VARCHAR(30) NOT NULL,RoleName VARCHAR(30) NOT NULL,StartDate DATETIME NOT NULL,EndDate DATETIME NOT NULL,CONSTRAINT `f_emp_id` FOREIGN KEY (EmpID) REFERENCES Employee (EmployeeID));

Answered: using the design file in the image…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

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.
4. Make sure to have a primary key for each table .
5. Make sure to include the relationships between the tables .

Bird's Eye ******
Zoom: 100% -
Catalog Tree ***
<
mydb
Tables
Views
Routine Groups
Catalog Layers User Types
Description Editor
Role: Table
Ready
Description Properties H ->
Diagram
↑
N
EEB
----
1:1
1:n
1:1
1:n
n:m
1:n
Employee
EmployeeID VARCHAR(45)
Name VARCHAR(45)
Email VARCHAR(45)
Dependent1 VARCHAR(45)
Dependent2 VARCHAR(45)
Dependent3 VARCHAR(45)
Indexes
0
0
■
0
Role
Name VARCHAR(45)
Email VARCHAR(45)
0
RoleName VARCHAR(45)
StartDate DATETIME
EndDate DATETIME
O
H
Vendor
◇Name VARCHAR(45)
Emp_Contact_Name VARCHAR(45)
Emp_Contact_Email VARCHAR(45)
Email VARCHAR(45)
Rediangmar Snip
A

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

can you provide me with details on the progression from 1NF to 3NF form with the relation between the tables along with the EER design?

thank you

Solution

by Bartleby Expert

SEE SOLUTION

Follow-up Question

the question said we need to include the relationships between the tables. can you please me with the details and figure showing the relationships between the tables?

Thank you

Solution

by Bartleby Expert

SEE SOLUTION

Similar questions