Design And Implementation Of Database For Shared Facility Reservation System In School

Abstract

This paper is a study on database design and implementation of reservation system for small shared facilities in schools. The reservation system has the characteristics that changes in the database must be communicated to the relevant users in real time. The database was designed using ERM from the requirements of the reservation system at school, and the database schema was derived from ERD, the result of ERM. In particular, it was implemented using Firestore provided by Google to notify related users of database changes in real time. For this, users and facilities data, which are core data, were designed and implemented to support efficient search by designing as the root of the hierarchical database.