StayWell is offering a monthly discount for residents who pay their rent on a quarterly basis. The discount is 1.75 percent of the monthly fee. For each property, list the office number, address, owner number, owner's last name, monthly rent and discount. The discount should be rounded to the nearest dollars.

Transcribed Image Text:

8 STAYWELL STUDENT ACCOMMODATION DATABASE StayWell finds and manages accommodation for owners of student accommodation in the Seattle area. The company rents out and helps to maintain 1-5-bedroom properties located in two main areas in the city, Columbia City and Georgetown. This is done on behalf of erty owners based both in the local area and throughout the United States. Each location is administrated by a different office, StayWell-Columbia City and StayWell-Georgetown. Module 1 StayWell wishes to expand its business. The current model relies on advertisements in student and university publications in print and online, but prospective owners and renters need to contact the offices and speak to an administrator on all matters relating to renting of properties. The office organizes maintenance services for a fee, which is also currently done via email or direct communication. Stay Well has decided that the best way to increase efficiency and move toward e-commerce-based business model is to store all the data about the properties, own- ers, tenants and services in databases. This will mean that the information can be easily accessed. StayWell hopes that these databases can then be used in future projects such as mobile apps and online booking systems. The data is split into several tables as described below. The OFFICE table shown in Figure 1-4 shows the office number, office location, address, area, city, state, and ZIP code. OFFICE OFFICE_NUM OFFICE_NAME 2 ADDRESS StayWell-Columbia City StayWell-Georgetown CITY STATE ZIP_CODE Columbia City Seattle WA Georgetown Seattle WA AREA 1135 N. Wells Avenue 986 S. Madison Rd FIGURE 1-4 Sample data for StayWell offices StayWell is split into two offices to better manage the properties. This management includes communicating with owners about the status and upkeep of their properties. They also facilitate the payment from the properties, meaning that the owners get regu- lar income without having to collect rent in arrears. Offices also advertise properties and place students in appropriate properties, facilitating initial visits and taking deposits. Lastly the office administers the maintenance of the properties, communicating with residents, owners, and maintenance services. This is discussed later. 98118 98108 ASO StayWell stores information about the owners of each property in the OWNER table, as seen in Figure 1-5. Each owner is identified by a unique owner number that consists of two uppercase letters followed by a three-digit number. For each owner, the table also includes the last name, first name, address, city, state, and ZIP code. Notice the owners are from across the United States. Although some apartments may be owned by a couple or a family, only the primary contact is given. Each property at each location is identified by a property ID, as seen in Figure 1-6. Each property also includes the office number that manages the property, address, floor size, the number of bedrooms, the number of floors, monthly rent per property, and the owner number. The property ID is an integer unique for each property. 8 STAYWELL STUDENT ACCOMMODATION DATABASE StayWell finds and manages accommodation for owners of student accommodation in the Seattle area. The company rents out and helps to maintain 1-5-bedroom properties located in two main areas in the city, Columbia City and Georgetown. This is done on behalf of erty owners based both in the local area and throughout the United States. Each location is administrated by a different office, StayWell-Columbia City and StayWell-Georgetown. Module 1 StayWell wishes to expand its business. The current model relies on advertisements in student and university publications in print and online, but prospective owners and renters need to contact the offices and speak to an administrator on all matters relating to renting of properties. The office organizes maintenance services for a fee, which is also currently done via email or direct communication. Stay Well has decided that the best way to increase efficiency and move toward e-commerce-based business model is to store all the data about the properties, own- ers, tenants and services in databases. This will mean that the information can be easily accessed. StayWell hopes that these databases can then be used in future projects such as mobile apps and online booking systems. The data is split into several tables as described below. The OFFICE table shown in Figure 1-4 shows the office number, office location, address, area, city, state, and ZIP code. OFFICE OFFICE_NUM OFFICE_NAME 2 ADDRESS StayWell-Columbia City StayWell-Georgetown CITY STATE ZIP_CODE Columbia City Seattle WA Georgetown Seattle WA AREA 1135 N. Wells Avenue 986 S. Madison Rd FIGURE 1-4 Sample data for StayWell offices StayWell is split into two offices to better manage the properties. This management includes communicating with owners about the status and upkeep of their properties. They also facilitate the payment from the properties, meaning that the owners get regu- lar income without having to collect rent in arrears. Offices also advertise properties and place students in appropriate properties, facilitating initial visits and taking deposits. Lastly the office administers the maintenance of the properties, communicating with residents, owners, and maintenance services. This is discussed later. 98118 98108 ASO StayWell stores information about the owners of each property in the OWNER table, as seen in Figure 1-5. Each owner is identified by a unique owner number that consists of two uppercase letters followed by a three-digit number. For each owner, the table also includes the last name, first name, address, city, state, and ZIP code. Notice the owners are from across the United States. Although some apartments may be owned by a couple or a family, only the primary contact is given. Each property at each location is identified by a property ID, as seen in Figure 1-6. Each property also includes the office number that manages the property, address, floor size, the number of bedrooms, the number of floors, monthly rent per property, and the owner number. The property ID is an integer unique for each property.

Answer rating: 100% (QA)

To provide a list that includes the office number address owners number owners last name monthly ren... View the full answer