The I.T. department of a medium-sized consulting firm requires an inventory system. This system would allow them to individually track every piece of computer. equipment used by the company. This includes computers, monitors, printers, etc. This is especially important given that the company has several offices located across world. The system should keep track of the following characteristics of equipment: • Its type (such as Computer, Monitor, Printer) • Its serial number (such as N3JEKW357EA) Its model number Information about its purchase (such as date, store, warranty expiration) Who is currently assigned to this piece of equipment Its location (such as Montreal Office, Toronto Office). • Every piece of Computer equipment has uniquely identifies with special barcode sticker (a piece of equipment can only be assigned to one employee at a time.) The system also keeps track of employees. The record has been following information: Name of the employee, gender. Title, department, supervisor. location. List of pieces of equipment currently assigned address, phone • List of pieces of equipment assigned to him/her in the past (and when !) Some information about locations is also stored: • Name of the location, Number of offices in that location, List of (references to) employees in that office, • Employee responsible for I.T. maintenance at that office and their contact number • List of equipment found at that location Draw the Class Diagram to model the above inventory system.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

The I.T. department of a medium-sized consulting firm requires an inventory system.
This system would allow them to individually track every piece of computer.
equipment used by the company. This includes computers, monitors, printers, etc.
This is especially important given that the company has several offices located
across world.

The system should keep track of the following characteristics of equipment:

• Its type (such as Computer, Monitor, Printer)

• Its serial number (such as N3JEKW357EA)

Its model number

Information about its purchase (such as date, store, warranty expiration)
Who is currently assigned to this piece of equipment

Its location (such as Montreal Office, Toronto Office).
• Every piece of Computer equipment has uniquely identifies with special

barcode sticker (a piece of equipment can only be assigned to one employee

at a time.)
The system also keeps track of employees. The record has been following
information:

Name of the employee, gender. Title, department, supervisor. location.
List of pieces of equipment currently assigned

address, phone

• List of pieces of equipment assigned to him/her in the past (and when !)

Some information about locations is also stored:

• Name of the location, Number of offices in that location, List of (references to)

employees in that office,

• Employee responsible for I.T. maintenance at that office and their contact

number

• List of equipment found at that location

Draw the Class Diagram to model the above inventory system.

Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Public key encryption
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education