This repository contains a collection of SQL scripts for creating and modifying an Airbnb-style database. The scripts include:
- airbnb-schema.sql: Contains the schema for the database, including the tables and their relationships.
- airbnb-data.sql: Populates the tables with sample data.
- airbnb-procedures.sql: Defines stored procedures for common database operations, such as adding and retrieving data.
- airbnb-triggers.sql: Defines triggers to enforce constraints and perform actions automatically when certain events occur.
- airbnb-users.sql: Creates user accounts and assigns permissions.
- airbnb-views.sql: Creates views to simplify querying the data.
- Install a MySQL server on your machine.
- Create a new database and run the SQL scripts in the following order:
- airbnb-schema.sql
- airbnb-data.sql
- airbnb-procedures.sql
- airbnb-triggers.sql
- airbnb-users.sql
- airbnb-views.sql
- Connect to the database using a MySQL client (e.g., MySQL Workbench, DataGrip, mysql command line).
Use the provided SQL scripts to create and modify the Airbnb-style database.