MySQL Workbench

MySQL Workbench for hotel_db

Workbench is a visual client for modeling (EER), writing SQL, and administration. For hotel_db you will use SQL Editor for scripts and EER diagrams before implementation.

SQL Editor supports multiple tabs — e.g. hotel_schema.sql and join_vezbe.sql. Query results appear in a grid; EXPLAIN runs in the same window. In hotel_db reception, finance, and housekeeping share gosti, sobe, rezervacije, placanja, and zaposleni — every change must stay consistent for all app modules.

In depth

EER Diagram lets you draw gosti, sobe, rezervacije with FK links before CREATE TABLE. Forward Engineer generates SQL — review before executing. In Workbench run the sample SQL on test data before production, check EXPLAIN as tables grow, and document expected results for teammates.

Key points

• SQL Editor for queries. — hotel_db example.
• EER model before SQL. — hotel_db example.
• Server Administration. — hotel_db example.
• Import/Export schema. — hotel_db example.
• EXPLAIN in same tool. — hotel_db example.

Common mistake

Clicking in GUI only without versioned .sql files — hard to reproduce hotel_db elsewhere. Typical fallout: mismatched reception vs finance data, lost reservations, or blocked check-ins at peak season — always backup before production DDL/DML.

Summary

Workbench is the main tool to design and test hotel_db in this course. Practice again on hotel_db until you can explain every result row and tie it to hotel workflows (check-in, billing, reporting).

Note: Tip: keep versioned .sql scripts (hotel_schema.sql, seed.sql) in Git — reproducibility matters when several people work on the same hotel_db model.