Skip to content

How it works?

Rashmika edited this page Sep 26, 2021 · 1 revision

The system automates the procedure of booking a meeting room in a company. Employees can import the users, search for the meeting rooms and book the meeting room based on their requirements.

The Automated Meeting Room Booking System is a 6 layered application consisting of View, Controller, Service, Validation, Data access and Database layers.

According to the functionalities, each of these layers have been further split into

1. View Layer

The view renders a presentation of modelled data. Being separated from the Model objects, it is responsible for using the information it has available to produce any presentational interface that the application might need.

In the view layer, JSP has been used to create the login pages. View layer helps the users to interact with the application.

2. Controller Layer

The controller is responsible for responding to the user input and to perform interactions on the data model objects. Controller helps to route the data which has been fetched from the database to the front end (view layer).

In the controller layer, HTTP Servlets has been used. User controllers have login controllers which help us in authenticating and authorising.

3. Service Layer

The service layer is an additional layer in an application that mediates communication between a controller and repository layer.

In the services layer, Java has been used. Services handles business logic of authentication and authorisation.

4. Validation Layer

The validation layer acts as an extra layer of protection.

In the validation layer, Java has been used. It is used to check whether the user input is valid

5. Data access Layer

The data access layer provides simplified access to data stored in persistent storage of some kind, such as an entity-relational database.

In this layer, Java has been used. Callable statements have been used to provide a layer of abstraction between the data access layer and the database.

6. Database Layer

In the database layer, MySQL has been used. Stored procedures have been used to optimise database queries and workflows. Apart from this, triggers, views and events have also been used.

The Database structure can be viewed here