This is the semester project for the course "Databases" at ECE-NTUA, in 2021.

Related tags

Database nodejs mysql database-design
Overview

Hotel Management project

Semester Assignments for Databases course, summer semester 2021

Concept

The project's concept is to create a system that manages and monitors access to certain facilities and services in a hotel complex, in order to ensure that safety protocols are applied during a pandemic.

Goals

The goals of the course was to get familiar with database design and implementation using SQL. That is the reason that we used pure SQL queries in the backend and not some more user friendly database querying tool/library.

ER Diagram

Based on the specifications provided by the professor, we designed the following ER diagram:

ER Diagram

Technologies

For the development of the project we utilized the technologies and tools listed below:

Contributors

Name
Apostolis Garos
Nikos Vlachakis

MIT LICENCE

You might also like...

A template for WebSockets powered Cloudflare Worker project using graphql-ws

🚡 graphql-ws on Cloudflare Workers A template for WebSockets powered Cloudflare Worker project using graphql-ws. The worker serves the following rout

Dec 18, 2022

A Gmail Clone which built with ReactJS and Redux. You can sign in with your Google Account, compose a new e-mail and send realtime emails to the project.

Gmail Clone with ReactJS A Gmail Clone that you can sign in with your Google Account, compose a new e-mail and send realtime emails to the project. Cl

Nov 14, 2022

Senior Design Project. Water intake tracker. Software for the communication to bottle and app. Software for app and database

WaterMate Senior Design Project. Water intake tracker to provide everyone with an easy to use water tracking system that can be integrated with your f

Nov 10, 2021

Database Engineering PHP Project

ICT502-Database-Engineering This repository contains the Database Engineering end-of-semester project. It uses PHP as the back-end processing language

Oct 11, 2021

Project-x - Данный проект несет за собой сугубо образовательный характер и не подразумевает получения финансовой выгоды.

Project - X Данный проект несет за собой сугубо образовательный характер и не подразумевает получения финансовой выгоды. Все наработки в рамках данног

Apr 12, 2022

The Wholesome App. A project that allows you to upload images directly to MongoDB Atlas into your collection, a faster cloud database.

The Wholesome App. A project that allows you to upload images directly to MongoDB Atlas into your collection, a faster cloud database.

The Wholesome App. A project that allows you to upload images directly to MongoDB Atlas into your collection, a faster cloud database. To upload your cute and wholesome images.

Jul 17, 2022

NodeJS,express and mysql starter project

NodeJS,express and mysql starter project

Node-express-mysql-starterproject NodeJS,express and mysql starter project Start with cloning the repo & Run npm i to download all the dependecies Aft

Dec 11, 2022

The Firma Project - Backend

The Firma Project - Backend

Firma About This is a backend for Firma Project. The Firma project is another corporate piece of software to engage employees to collaborate with othe

Feb 5, 2022

First NestJS project powered by TypeScript (Simple CRUD)

First Nest TS (TypeScript) First NestJS project powered by TypeScript (Simple CRUD) Routes Get All GET http://localhost:3000/products/ Get one GET htt

Feb 22, 2022
Comments
Owner
ApoGrs
ApoGrs
GitHub
ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.

TypeORM is an ORM that can run in NodeJS, Browser, Cordova, PhoneGap, Ionic, React Native, NativeScript, Expo, and Electron platforms and can be used

null 30.1k Jan 3, 2023
Peer-to-Peer Databases for the Decentralized Web

OrbitDB OrbitDB is a serverless, distributed, peer-to-peer database. OrbitDB uses IPFS as its data storage and IPFS Pubsub to automatically sync datab

OrbitDB 7.4k Jan 1, 2023
TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases.

TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite datab

MikroORM 5.4k Dec 31, 2022
TypeScript clients for databases that prevent SQL Injection

Safe From HTML Injection Using tagged template literals for queries, e.g. db.query(sql`SELECT * FROM users WHERE id=${userID}`); makes it virtually im

Forbes Lindesay 478 Dec 21, 2022
Explore, create and deploy your SQLite databases right from your browser. Quick and easy, no installation required.

SQLighter (under development, alpha code) SQLighter is a database explorer born for SQLite that helps you design and deploy your application database

sqlighter 11 Sep 20, 2022
📈 @GraphQL basic course on @Platzi by @edsadr

Basic GraphQL Course Take the course! While the course is pretty outdated and IMO uses some bad practices ?? , I learnt the basics of GraphQL. While t

Eliaz Bobadilla 7 Jun 1, 2022
Official turtleDB project

Overview • Getting Started • Features • Contributors • License • Overview turtleDB is a JavaScript framework and in-browser database for developers to

turtleDB 436 Dec 24, 2022
project overview tool, used to analyze the amount of code, the number of files, code statistics and so on.

pot z-pot is a project overview tool, used to analyze the amount of code, the number of files, code statistics and so on. 项目概述工具，用于分析代码量、文件数、代码统计等。 快速

zhangchi 18 Aug 10, 2022
Burger builder project using React, Hooks and Context API.

Burger Builder In this project, I made a context-api project by creating hamburgers with 3 different materials. Project setup npm install Project star

Efecan Pınar 4 Jun 17, 2021
Scratch project

onlydevs Only Devs for Lonely Devs (A dating application for you losers) Scratch project Front-end: REACT with Redux, react router dom for compenent r

null 3 Jul 8, 2021