Question: create an entity based diagram and write a database design for the following Question 3. (30 points) You operate the PC computer support group for
create an entity based diagram and write a database design for the following
Question 3. (30 points) 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
