Database schema design for Hospitality & Travel

Your prompt is ready 3 brackets to fill

You are an expert in this kind of work, and you know the Hospitality & Travel sector from the inside.

## Your task
Design a relational database schema for [APPLICATION] at a hotel group with its own booking site. Give the tables, columns with types, primary and foreign keys, indexes and constraints as SQL DDL for [DATABASE]. Explain normalisation choices and how the schema supports reporting on occupancy rate and guest review score.

## About my situation
- Who this is for: guests and travellers
- What we must respect: seasonal demand, booking-platform rules and guest safety

## What matters in Hospitality & Travel
- Rules and standards that usually apply: guest and fire safety; food-safety rules (FSSAI in India, local health codes); guest data privacy; OTA platform rules; tourism licences and taxes such as GST on room tariffs.
- Common risks to plan for: empty rooms in the off season; bad reviews; overbooking; dependence on OTA commissions; safety incidents.
- Tools commonly used: PMS; channel manager; OTAs (Booking.com, MakeMyTrip, Airbnb); Google Business Profile; WhatsApp.
- Words people in this field use: ADR; RevPAR; OTA; rack rate; upsell; no-show; F&B; banquet.
- Rules differ by country. If I have not said where I work, ask me, and do not present one country's law as if it applied everywhere.

## What I will give you
Requirements: [LIST REQUIREMENTS]

## How to work through it
1. List the entities and their relationships from the requirements.
2. Design tables with columns, types and constraints.
3. Add primary keys, foreign keys and indexes for the main queries.
4. Explain normalisation choices and any deliberate denormalisation.
5. Show how reporting queries will work.

## What to deliver
- SQL DDL
- An entity-relationship diagram in Mermaid syntax
- Design notes and trade-offs
- Two example reporting queries

## Rules
- Make every point specific to my situation and my industry; replace generic advice with detail that fits.
- Use plain language, short sentences, and tables where they make the answer easier to scan.
- Use only the facts I give you. Do not invent figures, laws, sources or quotes. Mark anything you had to assume with "Assumption:".
- If something important is missing, ask me up to 3 short questions before you start.

## Before you answer
Check your draft against this list and fix anything that fails:
- The code works as written: no invented libraries, functions or APIs, and versions are named where they matter.
- It is written for a hotel group with its own booking site; nothing in it would read the same for any other business.
- Nothing in it breaks seasonal demand, booking-platform rules and guest safety.
- Every item under "What to deliver" is included.

Open in ChatGPT Claude Perplexity

How to use this prompt

Copy the prompt. Press Copy prompt and the full text goes to your clipboard.
Fill the brackets. Use the form above, or replace [APPLICATION], [DATABASE], [LIST REQUIREMENTS] with your own details.
Paste and send. Paste it into ChatGPT, Claude and DeepSeek and send. Ask follow-up questions to refine the answer.

Why this prompt works

The “Database schema design” prompt tells the assistant exactly what to hand back: SQL DDL; an entity-relationship diagram in Mermaid syntax; design notes and trade-offs; and two example reporting queries. It makes the assistant work through 5 steps in order, starting with "list the entities and their relationships from the requirements", instead of jumping straight to an answer. Before replying, the assistant checks its draft against 4 tests and fixes anything that fails.

This version is written for a hotel group with its own booking site, so the assistant keeps seasonal demand, booking-platform rules and guest safety in mind and judges the result by occupancy rate and guest review score. If an important detail is missing, it asks you up to 3 short questions before it starts.

How to get the best answer

Fill every bracket with real detail: [APPLICATION], [DATABASE], [LIST REQUIREMENTS] should hold real names, numbers and dates, not placeholders.
Paste real material: where the prompt asks for notes, data or text, paste the actual content rather than a summary.
Refine in the same chat: ask "make it shorter", "turn it into a table" or "add more detail on step 2".
Check the result: review it against what you know about occupancy rate and guest review score before you share it.

Other industries

Same prompt for other industries

The same database schema design prompt, rewritten for each industry.

FAQ

Frequently asked questions

Which AI assistant works best with the “Database schema design” prompt?

The “Database schema design” prompt works in any chat assistant and suits ChatGPT, Claude and DeepSeek best. Paste it in, send it, and ask follow-up questions in the same chat to refine the answer.

What do I fill in before sending the “Database schema design” prompt?

Replace the 3 highlighted brackets – [APPLICATION], [DATABASE], [LIST REQUIREMENTS] – with your own details. The more specific you are, the better the answer.

Is the “Database schema design” prompt only for Hospitality & Travel?

No. This version is written for a hotel group with its own booking site, and the same prompt is also written for 15 other industries, listed on this page.

Is the “Database schema design” prompt free to use?

Yes. First AI Prompt prompts are free to copy and use in personal and business work, with no sign-up, no account and no daily limit.

Can I trust the answer the “Database schema design” prompt gives?

Treat it as a strong first draft: the prompt tells the assistant not to invent facts and to mark its assumptions, but check figures yourself, especially anything with legal, financial or safety consequences.

Keep exploring