• Presentations
  • Presentations
  • IMG 0341
  • Presentations
  • IMG 0409

List of entities and their corresponding attributes for Case Study 1

(3 votes, average 4.00 out of 5)

This is the first of three case studies that are used to guide the reader through the six steps outlined in Six-Step Relational Database Design™. Some of the outputs of the six step database design process are depicted here. Get a copy of Six-Step Relational Database Design™ to get the details of all six steps.

Scenario

Below is the scenario for Case Study 1 as described in Six-Step Relational Database Design™:

A small accounting firm wants a simple HR application that will help it to keep track of its employees, their positions, allowances, salary scales, and which company vehicles their employees drive.

The application must keep track of all the positions at the firm, the employees filling these positions, the allowances for these positions, the salary scales for these positions, and the company vehicles assigned to these positions.

 

List of entities and their corresponding attributes

Below is the list of entities and their corresponding attributes that is output from Step 1 of the six step database design process as described in Six-Step Relational Database Design™:

Employees
(PK) EmployeeId
SSNumber
LastName
FirstName
MiddleName
Gender
DOB
Email
Mobile
HTel
AddressLine1
AddressLine2
City
State
PostCode
Positions
(PK) PositionId
PositionName
PositionDescription
Details
Allowances
(PK) AllowanceId
AllowanceName
AllowanceDescription
Amount
SalaryScales
(PK) SalaryScaleCode
SalaryScaleName
SalaryScaleDescription
MinimumSalary
MaximumSalary
Vehicles
(PK) VehicleId
VIN
RegistrationNo
Year
Make
Model
Color

View the resulting Entity-Relationship diagrams for Case Study 1.