Overview

Assignment Four Practice Data Manipulation by using the SELECT command to manipulate data in one table. In this homework assignment, you will practice displaying data from multiple tables. Chapters in the Book

This assignment aligns with Chapter 5 in the textbook.

Learning Outcomes

  • The learning outcomes for this assignment are hands-on experience using Oracle SQL Live software, and understanding the SELECT command and its multiple variations by using this command to manipulate data in a single table.

Due Date(s)

  • See instructor distributed material and/or request a due date from the instructor

Instructions

  1. For this homework assignment, you have to create and insert the data for the SOLMARIS database.
  2. The create and insert commands can be found in the folder “DDL for Tables to be Used in Class/Homework.” This folder is found within “Information.”
  3. Copy and paste the DDL for the CREATE statements for the SOLMARIS database in the Oracle Live Worksheet and execute
  4. Copy and paste the DDL for the INSERT statements for the SOLMARIS tables in the Oracle Live Worksheet and execute
  5. Double-check to see the data is in the tables
  6. Once you have the tables and the data in the tables for the SOLMARIS database you can begin answering the homework questions below.
  7. The homework assignment has to include screenshots of the code and the output
  8. The screenshots should be pasted in this document so that screenshots for question one should be pasted under question one.

Assignment Grading

Each question is worth 10 points. Partial credit is given if part of the code is correct, however, if the code is correct but does not answer the assignment question, no credit will be given.

Additional Resources (in addition to the lecture and chapters in the textbook)

Assignment

  1. For every condo, list the location number, unit number, condo fee, owner number, owner’s first name and owner’s last name.
  2. For every condo with a square footage of more than 1000, list the location number, unit number, condo fee, owner number, owner’s first name and owner’s last name.
  3. List the location number, unit number, condo fee, owner number, owner’s first name and owner’s last name for owner numbers EL025, KE122, WS032 and whose square footage is greater than 1000. Order the output by owner number in descending order
  4. List the condo ID, location number, unit number, service ID, estimated hours, spent hours, owner number and owner last and first name. Order the output by owner number
  5. List the condo ID, location number, unit number, service ID, estimated hours, spent hours, owner number and owner last and first name for condo ID 14, 9, and 1. Order the output by estimated hours within condo ID.