In: Computer Science
SUBJECT: DATABASE SYSTEMS
!!! Please answer the question as early as possible !!!
Question 1
You are required to draw a complete Crow’s Foot ERD that includes
the following entity
relationship components based on the below descriptions:
i) Identify all of the entities and its attributes.
ii) Identify all possible relationships and its connectivity.
iii) Identify the primary key and foreign key for each
entity.
iv) Identify the participation constraint and cardinality for each
relationship.
A Super5 company contains many departments. Each department has
name and is identified
by department code. Each department employs many employees. An
employee can work only
in one department. Each employee has ID number, name, job
specialization, and email as the
attribute. Not all employees such as president and vice presidents
will be assigned a
department.
Manager within the employee may supervises at least fifteen
employees under his/her
supervision. An employee can be supervised by only one manage but
president and vice
presidents no need manager to supervise them.
Every year Super5 company will organized a fund-raising events to
aid an orphanage home.
During the event, a department needs to set up at most three
committees and each committee
handled by one and only one department. The committee has committee
id and committee
name. But not all departments need to set up a committee.
Each committee will be assigned to do many tasks. A task will be
completed by one and only
one committee. The maximum number of tasks per committee is five.
Special task will not be
handled by committee. The task will have the task number, task
name, assign date, and task
duration to be completed.
There are many employees’ becoming a member of the committee. Each
employee can work
in a committee based on the fund-rising event. This event will be
held from time to time basis.
Whenever an employee is participating as committee member in
fund-raising event,
participation date, event name, and position must be stored. Each
event will have a unique
code.
Question i) Identify all of the entities and its attributes.
Question ii) Identify all possible relationships and its connectivity.
Question iii) Identify the primary key and foreign key for each entity.
PK in the diagram are :
FK in the diagram are :
Question iv) Identify the cardinality for each relationship.
ERD diagram :
Thank you...........