Задание по БД

Нужно сделать эти задания до 8:00, всё прикрепил снизу:

/*CREATE TABLE Tours (

id_tour SERIAL PRIMARY KEY,

tour_name VARCHAR(100) NOT NULL,

discription TEXT,

date_start DATE,

date_end DATE,

price NUMERIC(10, 2),

id_hotel INTEGER

);

CREATE TABLE Hotels (

id_hotel SERIAL PRIMARY KEY,

name_hotel VARCHAR(100) NOT NULL,

adress VARCHAR(255),

rating INTEGER CHECK (rating >= 1 AND rating <= 5)

);

CREATE TABLE Clients (

id_client SERIAL PRIMARY KEY,

name_client VARCHAR(50) NOT NULL,

surname VARCHAR(50) NOT NULL,

email VARCHAR(100) UNIQUE,

phone VARCHAR(15),

date_birth DATE

);

CREATE TABLE Booking (

id_booking SERIAL PRIMARY KEY,

client_id INTEGER,

tour_id INTEGER,

date_booking TIMESTAMP DEFAULT CURRENT_TIMESTAMP

);

*/

CREATE TABLE Excursions (

id_excursion SERIAL PRIMARY KEY,

name_excursion VARCHAR(100) NOT NULL,

place VARCHAR(255),

price NUMERIC(10, 2),

date_excursion DATE,

id_tour INTEGER

);