Write an SQL for the Schema below and don't forget the primary key and foreign keys, and show what is NOT NULL$/$UNIQUE$?$

Feedback

$\backslash$table$[[$feedback$-$id$,$rating,comment,reservation$\_$id$]]$

Guests

guest$-$id

$44$

Reservations

$\backslash$table$[[$reservation$-$id$,$check$-$in$-$date,Check$-$out$-$date,guest$-$id$,$Bill$-$id$]]$

Invoice

bill$-$id

Payment$\_$method

amount

date

guest$-$id

Rooms

room$-$num

room$-$status

floor$\_$num

guest$-$id

hotel$-$id

Hotel

$\backslash$table$[[$hotel$-$id$,$hotel$\_$location,hotel$\_$address$]]$

Employees

emp$-$id

address

salary

hotel$-$id

Fills

Suite

room$-id$ room$-$num room$-$status floor$-$num CarParkingSpot

Single$-$Room

room$-$id

room$-$status

room$-$num

floor$-$num

Deluxe room

$\backslash$table$[[$room$-$id$,$room$-$num,room$-$status,floor$-$num$]]$

Receptionist

emp$-$id

Maintenance

Admin

Super$-$emplD