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.