Question
You operate the PC computer support group for a medium-sized company. You wish to keep records of the time your group spends servicing various personal
You operate the PC computer support group for a medium-sized company. You wish to keep records of the time your group spends servicing various personal computers within the firm. Each company-owned PC is identified by a unique property tag number; in addition, you want to record the PC's make and model, the room number where it is located, and the date it was acquired. Each computer "belongs" to a department of the company, identified by a department code. Each department also has a name. Some departments have only a few computers, but some have as many as a hundred. Every time one of your technicians services a computer, you want to record which computer was serviced, which technician performed the service, the date/time the service started, the date/time it ended, and a description of the work performed. Each technician is identified by an employee ID number; for each technician, you also want to store their first name, middle name/initial, last name, and date hired
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started