Same problem here. In my oppinion this test is broken. Always "Test#2 (incorrect answer)".

https://judge.softuni.bg/Contests/Compete/Index/286#12

13. Hotel Database

Using SQL queries create Hotel database with the following entities:

• employees (id, first_name, last_name, title, notes)

• customers (account_number, first_name, last_name, phone_number, emergency_name, emergency_number, notes)

• room_status (room_status, notes)

• room_types (room_type, notes)

• bed_types (bed_type, notes)

• rooms (room_number, room_type, bed_type, rate, room_status, notes)

• payments (id, employee_id, payment_date, account_number, first_date_occupied, last_date_occupied, total_days, amount_charged, tax_rate, tax_amount, payment_total, notes)

• occupancies (id, employee_id, date_occupied, account_number, room_number, rate_applied, phone_charge, notes)

Set most appropriate data types for each column. Set primary key to each table. Populate each table with 3 records. Make sure the columns that are present in 2 tables would be of the same data type. Consider which fields are always required and which are optional. Submit your CREATE TABLE and INSERT statements as Run queries & check DB.