Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create an EDR using Microsoft Access: The company is organized into departments. Each department has a unique number, name and a number of employees. One
Create an EDR using Microsoft Access:
The company is organized into departments. Each department has a unique number, name and a number of employees. One of the employees is the manager of the department. The company keeps track of the date each department's manager was appointed.
Each department controls a number of projects. Each project has a unique number, name and is located at a single location and controlled by only one department.
The company stores each employee's ID_number, address, salary, sex, and Date_of_birth. Each employee works for one department but may work on several projects although some employees do not work on any project. The company records the date an employee starts to work on a project and the date she stops working on that projects.
Each employee may have a number of dependants but a dependant is associated with only one employee. For each dependant, the company records their name, sex, Date_of_birth, and relationship to employee.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started