Back to the Data Model
A. The requirement is to maintain an Inventory of Servers,
and has been defined by the Users in the following terms :-
We need to create a database that will capture information
about the architecture here for our servers.
Information such as server name, service packs and patches, IP addresses,
technicians performing the work, date of installs, software (like operating systems),
descriptions, etc.
B. Things of Interest :-
B.1 Servers.
B.2 Service Packs and Patches.
B.3 Staff/Technicians.
C. How are they related ?
C.1 Service Packs are applied, by a member of Staff, to Servers.
C.2 Service Packs are applied only once.
If there is a problem, so that they have to be applied twice,
then only the last successful date is recorded.
Servers have IP Addresses.
Barry Williams
24th. May 2003
Principal Consultant
Database Answers