Kapyou prescious assignment.pdfjjhhgghhh

Would be best for you

1. Assignmemt
1.

Entities

Attributes
Common Attributes Unique Attributes
Manager Name Department_managed, Bonus
Technician Date of hire Skill_type, Certification level
Sales person Employee Id Sales person
Employee Salary

2. 2.

Employee
Id
Name
Date of
Hire
Salary
Employee
Manager
Technician
Sales person
Departm
ent
managed
Bonus
Skill Type Certification
level
Sales
region
Commissi
on

3. 3a.
.Employee ID
.Name
.Date of hire
.Salary
b.
Inheritance helps to reduce redundancy in database design by allowing shared attributes whereby a sub-entity can inherit common attributes from a parent
class to avoid repetition on an entity several times.

4. 4a.
Relationship Description
Employee and
Department
Every employee belongs to a department whereas, a department on its own can have
many employees
Employee and project An employee can work on many projects, and a project can have many departments to
whom it belongs
Department and project A department covers several/multiple projects but, each project belongs to a particular
department


b. Cardinality

N 1
NNnnnn



N N

EMPLOYEE AND DEPARTMENT
EMPLOYEE
AND
PROJECT

5. DEPARTMENT AND
PROJECT
1
N

6. 5. Specialisation.



M
EMPLOYE
E ID
NAME SALARY
DATE OF
HIRE
IS
A
EMPLOYEE
MANAGER
TECNNICIAN
CONSULTAN
T