This is a database for a system of hotels I projected for a university group project, using PostgreSQL. It involved:

• creating relational schema;
• creating queries;
• analyzing queries' execution through EXPLAIN ANALYZE;
• trying to optimize the queries;
• populating the database;
• avoiding SQLi;
• implementing user access control.

• Table, trigger and index creation can be found at script.sql
• Role creation and grants can be found at security.sql
• Queries and equivalent procedures can be found at queries.sql

• Ryan Sakurai
• Vinicius Castro

(Computer Science students at UFSCar - Federal University of São Carlos)