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

List of entities and their corresponding attributes for Case Study 2

(1 vote, average 5.00 out of 5)

This is the second 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 2 as described in Six-Step Relational Database Design™:

The owners of a small computer repair shop would like to keep track of the repair jobs for computers they repair, the items used for each repair job, the labor costs for each repair job, the repairmen performing each repair job, and the total cost of each repair job.

When customers bring their computers in to be repaired, they make a deposit on the repair job and are given a date to return and uplift their computer. Repairmen then perform repairs on the customers’ computers based on the repair job, and detail the labor costs and the items used for each repair job.

When customers return they pay the total cost of the repair job less the deposit, collect a receipt for their payment, and uplift the repaired computer using this payment receipt.

 

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™:

RepairJob
(PK) JobNum
DateReceived
DateToReturn
DateReturned
DateStarted
DateEnded
RepairDetails
LaborDetails
LaborCost
TotalCost
PaidInFull
AdditionalComments
Computers
(PK) ComputerId
SerialNum
Make
Model
ComputerDescription
Items
(PK) ItemId
PartNum
ShortName
ItemDescription
Cost
NumInStock
ReorderLow
Repairmen
(PK) RepairmenId
LastName
FirstName
MI
Email
Mobile
HTel
Extension
Customers
(PK) CustomerId
LastName
FirstName
MI
Email
Mobile
HTel
AddressLine1
AddressLine2
City
State
PostCode
Deposits
(PK) DepositNum
DepositDate
Amount
Payments
(PK) PaymentNum
PaymentDate
Amount

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