Trouble Ticket Problem Statement

Design a database for Kishwaukee College to track information technology inventory information, operational
status, location, and user assignment.  IT personnel shall be able to update inventory information,
change the operational status, add historical data to the status of inventory items, change the location
of the inventory items, and change the user assignments of inventory items.  IT personnel shall be able
to determine if an inventory item is configured appropriately to satisfy a particular user's requirements.
IT personnel shall be able to query the database to find inventory of like types, configurations or
locations.  IT personnel shall be able to query the database to find users with like requirements.

User data shall include name, office or department information, room number, telephone number, E-mail address,
network login ID, additional required applications (associated with user or position?), employee type.

Item data shall include serial number, Kishwaukee ID number, Item (computer system, display, printer, other)
Date purchased, original cost, warranty duration, date last moved

Item
- Serial Number (key) (bar code)
- Kish ID (bar Code)
- Item Type
- Date Purchased
- Original Cost
- Warranty Duration
- Date last moved
- Location
- User

Computer System (item type)
- Serial Number
- manufacturer
- model ID
- operating system (last updated or installed?)
- processor type
- processor speed
- drive types
- applications installed
- associated items (display, printer, other)?


(later)Drives (computer system):
- Serial Number (key)
- HDD (size, speed, interface type)
- CD-ROM
- CD-RW
- DVD-ROM
- CD-RW/DVD-ROM
- CD-RW/DVD-RW
- FD
- other

Diplay (item type)
- Serial Number (key)
- manufacturer
- model ID
- type (LCD, CRT, other)
- size (diagonal)

Printer (item type)
- Serial Number (key)
- manufacturer
- model ID
- type (color ink jet, b/w laser, color laser, dot matrix, other)
- network information (include network print servers?)