Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In ABC company, the following employee information is stored: Employee ID, First and Last name, Area code, Phone number, Zip code, and Street address. Employees
In ABC company, the following employee information is stored: Employee ID, First and Last name, Area code, Phone number, Zip code, and Street address. Employees are organized into specialties, each specialty has a manager of that specialty, who is coordinating the assignment of all employees in that specialty to the projects. For each specialty, the company records the specialty ID and name. An employee belongs to only one specialty. A new employee may not have any specialty yet. The system stores the information about projects. For each project, the following information is stored: Project ID, Status, Location. More than one employee can be assigned into the project. When an assignment is requested for an employee, the employee is scheduled to work on a particular project, for the specified amount of his full available time (10%-100%). So, one employee can be assigned in multiple projects
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