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:
The following database tables are used to represent the above entities and relationships.
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.