StayWell focuses on finding and managing accommodation for owners of student accommodation in the Seattle area. Currently, it operates in two main areas of the city with separate administrative offices: Colombia City and Georgetown. StayWell rents out 1 to 5-bedroom properties to students on behalf of property owner 7. You are assigned, as the database administrator, to collect and manage transactional data of the StayWell operations. You will begin by creating the database and tables for StayWell and will transfer the collected data. Then, you will need to execute further database operations as StayWell's operations expand.

TheOFFICEtable contains information about the two StayWell office locations, including the office number, office name, and address.

^{OFFICE table}

TheSERVICE_CATEGORYtable contains information regarding the different service categories, such as their numerical designation and description.

^{SERVICE_CATEGORY table}

TheSERVICE_REQUESTtable contains information on service requests for each property. TheSERVICE_REQUESTtable stores the service ID, property ID, service category number, the managing office ID, request description, the request's status, estimated hours, hours spent, and the service date.

^{SERVICE_REQUEST table}

TheRESIDENTStable contains the information on each resident, such as their resident ID, first name, surname (last name), and property ID.

^{RESIDENTS table}

TheOWNERtable contains information on each property owner, such as their owner number (ID), last name, first name, and address.

^{OWNER table}

ThePROPERTYtable contains information on each property, including the property ID, managing office number, address, square feet, bedrooms, floors, monthly rent, and the owner.

^{PROPERTY table}

Project Objectives

• Create, use, and drop views
• Update the data over views instead of tables
• Create and test constraints such as foreign keys
• Use mathematical functions over numerical data
• Calculate dates with SQL functions
• Create triggers before inserting data into tables

Best practices to follow:

• Write detailed comments for SQL statements.
• Organize and structure SQL statements for readability

Create a COLOMBIA_CITY_PROPERTY VIEW to filter the properties managed by the Columbia City office where OFFICE_NUM equals to 1.