Project Objectives

Creating tables with various data types

Inserting data to the database tables

Updating and deleting data from database tables

Running complex queries to make calculations over database tables

Best Practices to Follow:

Write detailed comments for SQL statements

Organize and structure SQL statements for readability

Your tasks are as follows:

StayWell manages the owner information about every property under their management. Since the owners are essential to the operations, their addresses $($with city, state, and zip code$)$ are collected. Create the OWNER table, it should have the following data:

OWNER$\_$NUM as fixed$-$length $5$ characters

LAST$\_$NAME as maximum $20$ characters

FIRST$\_$NAME as maximum $20$ characters

ADDRESS as maximum $100$ characters

CITY as maximum $20$ characters

STATE as fixed$-$length $2$ characters

ZIP$\_$CODE as fixed$-$length $5$ characters

All fields are mandatory and cannot be empty

StayWell stores and manages the detailed information about the properties within their operations. Each property is assigned to an office for its management activities. In addition, property$-$specific information such as the house size, number of bedrooms and floors, and monthly rent are also kept. Each property has an owner reference. Considering the future expansion of StayWell, all properties should be managed within the database. Create the PROPERTY table, it should have the following data:

PROPERTY$\_$ID as small integer

OFFICE$\_$NUM as tiny integer

ADDRESS as maximum of $100$ characters

SQR$\_$FT as small integer

BDRMSas tiny integer

FLOORS as tiny integer

MONTHLY$\_$RENT as small integer

OWNER$\_$NUM as fixed$-$length $5$ characters

All fields except monthly rent are mandatory and cannot be empty.