Write an SQL for the Schema below and primary key and foreign keys must be defined and Define attributes, data types, constraints e$.$g$.$ NOT NULL$/$ UNIQUE?

Feedback

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

Guests

guest$-$id

phone num

address

email

name

Reservations

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

Invoice

bill$-$id

Rooms

room$-$id

Hotel

Hotel

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

Employees

emp$-$id $$

Payment$\_$method

amount

date

guest$-$id

Fills

Makes

Suite

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

Single$-$Room

$\backslash$table$[[$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