You’ve been hired to create a data model to manage repairs on laptops in a laptop repair shop. Clients bring in their laptop computers and book them in for repairs, possibly multiple times. Here’s some info collected during a meeting with the owner: • Once a client brings in their computer for repairs, both they and their laptop are registered on the system along with the booking. • A repair involves a specific laptop (identified by its serial number) and a specific client. Once the laptop is booked in, the client is given a unique number that they can use to query the status of the repairs on this laptop. • Information stored on laptops (apart from the serial number) include: make (e.g. Dell, HP, Lenovo etc.), size (e.g. 10-inch, 13-inch, 15-inch etc.), HDD size, RAM size, and a few others. • One or more parts may be used to repair a given laptop, which may or may not be used in the repair process, depending on what was wrong with the laptop. Examples of parts are: RAM (of various makes and sizes), mother board etc. • The shop currently has two technicians, but may expand in future if business is good. Each technician picks up and handles a repair from beginning to end. As always, the first step in the process is to infer the entities. That is all you’re required to do in this question: identify all the entities
You’ve been hired to create a data model to manage repairs on laptops in a laptop repair shop.
Clients bring in their laptop computers and book them in for repairs, possibly multiple times. Here’s
some info collected during a meeting with the owner:
• Once a client brings in their computer for repairs, both they and their laptop are registered
on the system along with the booking.
• A repair involves a specific laptop (identified by its serial number) and a specific client. Once
the laptop is booked in, the client is given a unique number that they can use to query the
status of the repairs on this laptop.
• Information stored on laptops (apart from the serial number) include: make (e.g. Dell, HP,
Lenovo etc.), size (e.g. 10-inch, 13-inch, 15-inch etc.), HDD size, RAM size, and a few
others.
• One or more parts may be used to repair a given laptop, which may or may not be used in
the repair process, depending on what was wrong with the laptop. Examples of parts are:
RAM (of various makes and sizes), mother board etc.
• The shop currently has two technicians, but may expand in future if business is good. Each
technician picks up and handles a repair from beginning to end.
As always, the first step in the process is to infer the entities. That is all you’re required to do in
this question: identify all the entities
Step by step
Solved in 2 steps
