Facilities%20DB%20Application

1
Facilities DB Application

• Chao Wang, Chiaoching Huang, Xiaoming Li, Shaoen
  Wu

2
Project description

• Develop a database application for facility
  division employee to administrate facilities in
  each location on campus.
• Some group did part of the work and we continue
  theirs.

3
Requirement

• Be similar to current paper forms being used in
  work, which outlines our interface.
• Relationship

1
1
Building
Storage room
1
1
1
Lounge room
M
Apartment/Dormitory room
4
Requirement (Cont.)

• Insert different facilities (like mattress,
  couch, etc) into different room
• update data for each room when there is any
  change
• Generate report for each room based on
• Some date
• One arbitrate period time
• Monthly
• Yearly

5
System configuration

• Hardware
• More than one PC for database server or client
  remote work
• Software
• Window system with browser like IE, Firefox, etc.
• MySQL database

6
Heuristic evaluation

• Affordances, mappings Constraints
• Nice.
• No sub pages for links so no color change.
• Maybe give feedback on what exactly is entered
  into database after its inserted
• Language
• Fairly simple and easy to understand
• Easy but dont see any place to get help

7
Heuristic evaluation (Cont.)

• Layout
• Functional but not very appealing
• Fairly technical look
• Color
• Good color matching Auburn scheme
• Consider adding more graphical images into pages
  to be more attractive

8
Heuristic evaluation (Cont.)

• Tone Etiquette
• The tone is fairly technical. Feels like you know
  what you do
• Straight forward tome appropriate for this
  application
• Special consideration
• Seems to be fairly standard

9
Usability test

• Not done yet.

10
Database ER Diagram
ItemType
ID
Type
Building
ItemID
Name
room
item
1m
m1
Pattern
Color
room_item
UpdateTime
Comments
Quantity
11
Data Input Interface

• www.auburn.edu/lixiaom/code/