Reference no: EM1335477

Create and populate tables within a database using MS Access that supports the following business rules:

Employees all have employee ID's, first names, last names, middle initials, street addresses, city, state, postal codes, and a date of birth.

Departments all have department IDs, department names, and a department description, and a department manager..

An employee can work for only one department.

Each department can have multiple employees but only one manager.

Create 5 fictional employees within the employee table.

Create 2 fictional departments within the department table of the database.

Products each have a product ID, product name, product description, weight, and vendorID.

Vendors each have a Vendor ID, Vendor name, address, city, state, and postal code.

Products can be ordered from multiple vendors and Vendors can ship multiple products. (hint: you need to resolve this many to many relationship somehow)

Create at least 4 fictional products

Create at least 3 fictional vendors.