Database design document

The main database used to query and generate reports in the TUChem system. The tables listed

are the tables that we used in the project this semester. At the end of the listing there are tables

that are included in the databases that are unused.

TUCHEM_DEVELOPMENT DATABASE

Table 1: CAMPUS (Contains a list of campus names and ids)

Table Attributes

cmp_id, name

Table 2: BUILDING (Contain a list of campus building names and ids)

Table attributes

BID, name

Table 3: LOCATION (Contains information each specific location where inventory are kept)

Table attributes

floor, location, room, cmp_id, BID, LID, cp_id

Table 4: INVENTORY (Contains information about the items in the inventory)

Table attributes

LID, Units, CAS #, chemical_id, Qty, Size of Container, Size of Container, Chemical name

Table 5: CPOINT (Contains control point names and ids)

Table attributes

name, cp_id

Tables in the database that was unused this semester.

Counters, inv_totals, item_info, items, messages, user_class

Database Notes

This database is the meat and potatoes of the system. It is purposely simple

so it can be easily followed by future groups who will work on the project.