1. Database Design

This system uses a database to store the information about users, resources and schedules. The database system used is the Microsoft Access and a JDBC interface is used to access the database.

5.1 Database Modeling Design

The database stores the following information for the system:

The following ER graph represent the relationship among these entities:

 

    1. Database Table Design

The following database tables are used to represent the above entities and relationships.

String UserName

String Password

String RoomName

Int Size

String EquipmentID

String EquipmentType

String Description

 

 

Int EventID

Date StartDate

Time StartTime

Date EndDate

Time EndTime

String Location

String Description

String UserName

Int EventID

String RoomName

Int EventID

String EquipmentID

Int EventID

 

    1. Getting Access To The Database

In this system, the server get access to the database system using a JDBC interface. In order to maintain the consistency of the database content, we used the transaction for each series of database update operation. The related update statements (Insert and Delete) are organized into a transaction and executed as a whole. In this way, we effectively maintained the consistency between the information stored in different tables. And since the database system provide exclusive use of the database resource within a transaction, it also avoid the interference between different user accessing database simultaneously.