Access Project – 5 fictional employees, 2 fictional departments, 4 fictional projects & 3 fictional vendors – Guaranteed 100% score

Lab Price = $14
[orb_cyber_store id=”499″]
Please feel free to send us your queries at: support@iqrajavaid.com
Problem Statement

Create and populate tables within a database using MS Access that supports the following business rules:
1. Employees all have employee ID’s, first names, last names, middle initials, street addresses, city, state, postal codes, and a date of birth.
2. Departments all have department IDs, department names, and a department description, and a department manager..
3. An employee can work for only one department.
4. Each department can have multiple employees but only one manager.
5. Create 5 fictional employees within the employee table.
6. Create 2 fictional departments within the department table of the database.
7. Products each have a product ID, product name, product description, weight, and vendorID.
8. Vendors each have a Vendor ID, Vendor name, address, city, state, and postal code.
9. Products can be ordered from multiple vendors and Vendors can ship multiple products. (hint: you need to resolve this many to many relationship somehow)
10. Create at least 4 fictional products
11. Create at least 3 fictional vendors

Screenshots

screenshot_RelationshipDiagram

screenshot_EmployeeTable

Instructions
* Please click on “Buy Now” button to complete the purchase.Please note that the payment is done through PayPal.
* If you have any issues with the payment method, please let us know at support@iqrajavaid.com and that can be discussed and considered.
* Your paypal has to be pre-loaded in order to complete the purchase or otherwise please discuss it with us at support@iqrajavaid.com.
* As soon as the payment is received through PayPal, download link of the solution will automatically be sent to the address used in Paypal.
* Please check your junk mails as the download link email might go there.
* All the contents are compressed in one zip folder.
* In case if you get stuck at any point during the payment process, please immediately contact us at support@iqrajavaid.com and we will fix it with you.
* We try our best to reach back to you on immediate basis. However, please expect to get a response within 8 hours from our side.
* Comments/Feedbacks are truely welcomed and there might be some incentives for you for the next lab/quiz/assignment.
* In case of any query, please donot hesitate to contact us at support@iqrajavaid.com.

******************************************** Good Luck ***************************************************

Privacy Policy
We take your privacy seriously and will take all measures to protect your personal information.
Any personal information received will only be used to fill your order. We will not sell or redistribute your information to anyone.
Refund Policy
Incase you face any issues with the tutorial, please free to contact us on support@iqrajavaid.com
We will try our best to resolve the issue and if still persists we can discuss for a refund in case its required.
Payment Details
Lab Price = $14
[orb_cyber_store id=”499″]
Please feel free to send us your queries at: support@iqrajavaid.com

Leave a Reply