Scribd
Upload
31 views2 pages

Data Modelling Assignment

The document outlines four data modeling assignments for BookMyShow, a food delivery app, an airline reservation system, and a healthcare application. For each assignment, it lists 10 common business insights that can be derived from the data model and instructs the candidate to design the optimal data model diagram and include SQL queries for each business insight.

Uploaded by

Gorre Rohith
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
31 views2 pages

Data Modelling Assignment

The document outlines four data modeling assignments for BookMyShow, a food delivery app, an airline reservation system, and a healthcare application. For each assignment, it lists 10 common business insights that can be derived from the data model and instructs the candidate to design the optimal data model diagram and include SQL queries for each business insight.

Uploaded by

Gorre Rohith
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Data Modelling Assignment

1. Design Data Model for BookMyShow

We need to derive below mentioned business insights from


the data model:

1. The most popular movie genres in specific locations.


2. The busiest time of the day/week for movie bookings.

ills
3. The percentage of customers who book tickets for
other events (like plays or concerts) after booking
movie tickets.

Sk
4. The average number of tickets booked per transaction.
5. The rate of booking cancellations.
6. The impact of pricing on booking volume.
7. The correlation between star cast and movie bookings.
a
8. The number of new users acquired each month.
9. The most effective marketing campaigns in terms of
at
user acquisition or revenue.
10. The revenue generated from each movie theatre.
D

Note: Prepare your data model and share the diagram in


your solution along with the SQL queries for each problem
w

statement.
ro

2. Design Data Model for food delivery app like Zomato/Swiggy


G

We need to derive below mentioned business insights from


the data model:

1. The most popular restaurants in specific locations.


2. The busiest times of day/week for food orders.
3. The average order value for each customer.
4. The average delivery time for each restaurant and/or
delivery personnel.
5. The most commonly ordered cuisines.
6. The rate of order cancellations.
7. The impact of pricing and discounts on order volume.
8. The revenue generated from each restaurant.
9. The number of new customers acquired each month.
10. The most effective marketing campaigns in terms of
user acquisition or revenue.

Note: Prepare your data model and share the diagram in


your solution along with the SQL queries for each problem

ills
statement.

Sk
3. Design Data Model for Airline Reservation System

Think about the most common business insights which you


can pull out from the data model.
a
at
Note: Prepare your optimal data model and share the
diagram in your solution along with the SQL queries for each
D

business insight

4. Design Data Model for Healthcare application like Practo


w

Think about the most common business insights which you


ro

can pull out from the data model.


G

Note: Prepare your optimal data model and share the


diagram in your solution along with the SQL queries for each
business insight

You might also like