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

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.

© SolutionLibrary Inc. solutionlibary.com July 10, 2020, 10:01 pm 9836dcf9d7 https://solutionlibrary.com/computer-science/data/create-and-populate-tables-within-a-database-using-ms-access-that-supports-the-following-business-rules-f4de