Introduction to SQL help.

Download the following design file employee.mwb (Picture of the file is shown above)

Be aware of the possibility of duplicate data.

a) Name in Role and Employee and Emp_Contact_name all refer to the same data.

b) Name and Email in Vendor refer to the Vendor.

c) Make sure to have a primary key for each table

d) Make sure to include the relationships between the tables

e) An employee may have many roles over the employee's work history and a record should be retained for each role.

Assumptions made:

f) An employee works with one or more vendors.

g) An employee may have none or many dependents.