Make a postgres script for this please

Resort Management System provides you with accurate reservation tracking,

excellent web presence, powerful report generation, comprehensive integrated

accounting and more$($Database Design for Resort Management System Project$).$

It is a place with pleasant environment to comfort, healthful relaxation and rest,

offering food, sleeping accommodation and recreational facilities to the public for

a fee.

A modern hotel unit must adapt to these new standards, or risk falling behind its

competitors. A resort nowadays needs to be connected to several online sales

channels, while at the same time, maintaining a strong online presence of its

own. The use of a modern RMS $($Resort Management System$)$ can assist towards

that end, by providing the necessary work structure, much needed automation

and connectivity$($ERD and Tables for Resort Management System$).$

Resort Management System Features

Manage Guest

Monitor Transaction

Generate Report

Manage Employee