Resort-Management-System

-> A database management project using DBMS techniques
-> project-Description.pdf holds all the information about the project and the assumptions we made to implement this project.
-> pro.sql file contains the struture of the database or the tables.
-> data.sql holds dummy data.
-> This project is built using database techniques like all the tables are in BCNF form.
-> There is a file finalQuery.pdf that conatins sample queries that can be forms on this dataset and it also contains respective sql queries for retrieval.
-> projectNormalization.pdf holds the proof that every table is in BCNF form by using functional Dependencies concepts.
-> Project_ER.pdf holds the Entity Relationship diagram.
-> RS1.pdf holds the schema diagram for resort management system.