ISAM 5635 M-W 6-8:30 PMAbena S. Sandy #0094882
Database AssignmentJuly 9, 2007
Equipment Inspection Tracking System
Business Model
Our company creates software that monitors equipment that needs to be inspected on a regular basis. Many organizations must inspect their equipment, whether those inspections are determined by organizational policies or by government regulations. By inspecting equipment regularly, organizations can determine if equipment is not operating efficiently, needs to be replaced, needs to be repaired, etc.
The proposed system will contain data regarding the organization’s departments, equipment, locations, types of inspections, and inspectors. The proposed system will also contain information on the location of each piece of equipment, what department is responsible for the equipment, when the equipment was inspected and by what inspector, and what is the inspection status of each piece of equipment. The proposed system will have an easy-to-use interface that will allow users to add, modify, or delete data from the system. The proposed system will also allow users to report on when equipment were inspected, who inspected the equipment, their inspections status, and other beneficial information.
The proposed system will create business value for organizations by allowing the organization to store and analyze equipment inspection data to prevent any impending equipment failures and/or to ensure compliance of government regulations.
Entities and Attributes
Entity: Department
DEP_ID
DEP_NAME
Entity: Equipment
EQ_ID
DEP_ID
EQ_NAME
Entity: Location
LOC_ID
LOC_BLDG
LOC_ROOM
Entity: Inspector
INSP_ID
INSP_FNAME
INSP_LNAME
INSP_PHONE
INSP_EMAIL
Entity: Inspection Type
INST_ID
INST_NAME
INST_FREQ (i.e. DAILY, WEEKLY, MONTHLY, YEARLY)
INST_INSTRUCTIONS
Entity: Inspection Status
INSS_ID
INSS_STATUS (i.e. PASS, FAIL, IN PROGRESS)
INSS_REASON
Logical Design
The logical design of the database is represented by the entity relationship diagram below:
Physical Design
The physical design of the database is detailed below:
Department(DEP_ID, DEP_NAME)
Equipment(EQ_ID, DEP_ID, EQ_NAME)
Location(LOC_ID, LOC_BLDG, LOC_ROOM)
Inspector(INSP_ID, INSP_FNAME, INSP_LNAME, INSP_PHONE, INSP_EMAIL)
Equipment Location(EQ_ID, LOC_ID)
Equipment Inspection(EQ_ID, INSP_ID, INST_ID, INSS_ID, EI_INSPECTDATE)
Inspection Type(INST_ID, INST_NAME, INST_FREQ, INST_INSTRUCTIONS)
Inspection Status(INSS_ID, INSS_STATUS, INSS_REASON)
Implementation
The physical design was implemented using Microsoft Access.
Table and Relationships
Forms
Reports
Page 1 of 5