Build each table to the specifications defined in the database model by running the Unit $9$ Lab Database Reset.

$2.$ INSERT a new, and active, property to the database with a name of Hotel Scholastica $$ Duluth$2,$ a manager of Bob Dylan, located at $101$ Summit Street in Duluth, MN with a zip code of $55803$ and a phone number of $2182921672.$

HINT: make sure you use a new PK number.

$3.$ INSERT a new building for the hotel created in #$2.$ The new, and active, building is named BlueStone Lofts and is $15$ stories tall with air conditioning.

HINT: make sure you use the same property$\_$id created

in Question #$2$ as the FK$.$

$4.$ INSERT a room for the building created in #$3.$ This new active room is room number $101$ and is an Accessible, non$-$smoking room priced at $$205\mathrm{.}00$ per night.

HINT: make sure you use the same building$\_$id created in Question #$3$ as the FK$.$