CKZiU room reservation system

contractor: Jan Kowalski

principal: Michał Czerwiński

dossier version	date	description
1.0	17.11.2021	none
1.1	17.11.2021	adding ERD
1.2	25.11.2021	adding organizational structure
1.3	26.11.2021	adding layout form in HTML
1.4	29.11.2021	database with only tables - sketch a database without establishing a relationship
1.5	30.11.2021	add wireframes

Abstract

The project concerns a system that allows for the booking of all rooms at the Center for Vocational and Continuing Education. On the following streets (in Brodnica):

• Mazurska 28
• Aleja Leśna 2
• Karbowska 29

Data structure

data	type
INPUT	data form
OUTPUT	room reservation message and database entry

Main functionalities

1. relational database based on SQL language
2. frot-end created in JavaScript and CSS technologies
3. back-end executed in PHP language and auxiliary scripts

The above functionalities are tested and work according to their roles.

As a contractor on the project, I certify that the above functionality does not compromise cyberspace or any other space of any state. The code contained in the project, does not contain malware and is safe to use. I am personally responsible for its operation: Jan Kowalski.

Entity Relationship Diagram

link to diagram ERD in jpg

Organizational structure diagram

link to diagram OSD in jpg

Cpecific functionalities

A subsection that presents a detailed description of the individual functionalities on which the main functionalities are based.

Relational database based on SQL language

Frot-end created in JavaScript and CSS technologies

Back-end executed in PHP language and auxiliary scripts

Technologies, programming languages and others

• [PHP]
• [JS]
• [CSS/HTML]
• [SQL]
• [MySql/MariaDb]
• [Apache]

Layout for form in HTML

link to layout

Sketch a database without establishing a relationship

link to sketch a database

Example of an empty wireframe of the main form on a subpage

Wireframe empty

Wireframe the main form on the application subpage

Wireframe the main form