Outdated Task Variants

Variant 1: Database "Music Catalog"

Level: Easy

Description: Design an online music catalog that allows registered users to publish their own music.

Each musical composition will have a title, authors, genre, save file format, and tags.
Authors can be one or several registered users. Authors can add supporting materials such as text, music, and graphic logos.
Only registered users can leave comments on compositions, and authors can respond to comments, forming a conversation tree.

Minimal Set of Base Tables:

Minimum Set of Table Fields:

Level: Medium

Description: Design a database for a travel agency that provides services for organizing vacations at resorts.

Each resort has a type (mountain-ski, sea, etc.), quality level (in stars), country, location, and cost of recreation.
Each resort provides photos that are available to the general public, and clients can comment on these photos.
Clients choose a resort, and an agency employee signs the contract. Agents receive commissions from each signed contract.

Minimal Set of Base Tables:

Minimum Set of Table Fields:

Level: Hard

Description: Design a database for a hotel where clients book rooms for certain periods.

Rooms have a number of beds and types (economy, standard, luxury, etc.), which determine the cost of living.
The hotel administration can generate a check-in/check-out schedule and room popularity ratings.
The hotel also offers a car rental service, providing information about available cars (manufacturer, brand, number of seats, color, price) and records agreements with clients (term, car).
Each car rental agreement includes an insurance contract, signed by insurance agents who receive commissions.

Minimal Set of Base Tables:

Minimum Set of Table Fields: