Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
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: 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 .

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: 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 .

Computer Networking: A Top-Down Approach (7th Edition)
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
icon
Related questions
Question

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

Normalize the database in the design file

  1. Be aware of the possibility of duplicate data.
  2. Name in Role and Employee and Emp_Contact_name all refer to the same data.
  3. Name and Email in Vendor refer to the Vendor.
  4. 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
Transcribed Image Text: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

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
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
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
Bartleby Expert
SEE SOLUTION
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS