Database Reference
In-Depth Information
10.
What are the two dominant contemporary models for
database design, implementation and management?
{02}
a.
b.
Section B: Answer one question from this section
11.
Precision Software Inc. is a software engineering firm
contracted to develop and implement a Human Resource
Management System (HRMS) for Zealot Industries Inc. After
a preliminary meeting with Zealot's senior management,
the lead software engineer on the Precision Software team
documents his findings as follows:
·
A detailed employee profile consists of the employee's
personal information, employment history, education
history and beneficiary information.
·
Every employee belongs to a department, and is assigned
a specific job description (there may be more than one
employees with the same job description).
·
Employees are classified according to the salary range that
they fall in.
·
Each employee has a compensation package which outlines
basic salary and other benefits. Benefits include health
insurance, retirement plan, life insurance, professional
development allowance, housing allowance, traveling
allowance, entertainment allowance, vacation allowance,
and education allowance.
·
A payroll log keeps track of remuneration paid out to
employees.
·
Each employee is assigned to at least one project; the
number of employees assigned to a project depends on the
size and complexity of the project.
11a.
Identify all information entities (object types) mentioned or
implied in the case.
{05}
11b.
Identify all relationships among the entities (or object types)
and represent them on an ERD or ORD.
{15}
