Task 1 Create a schema called “BuildingGo” and then write DDL queries to create the three tables with relevant keys as suggested in the above diagram and the sample data shown in the tables.

For tasks, 4-24, make sure to insert data that satisfy the criteria before executing them.
Task # Task Description
Task 1 Create a schema called “BuildingGo” and then write DDL queries to create the three tables with relevant keys as suggested in the above diagram and the sample data shown in the tables.
Task 2 Write queries to insert 5 records into Owner and Building each.
Task 3 Write queries to insert 10 records into the Apartment table.
Task 4 Write a query to display all the information about the buildings in the Building table.
Task 5 Write a query to display the building names of all buildings in the Building table.
Task 6 Write a query to display all the building names and their capacity.
Task 7 Write a query to update the Building_Capacity of ‘Lilly Pilly’ to 2000 people.
Make sure to insert some data that satisfy the criteria before executing the query.
Task 8 Write a query to display the Building_ID and Building_Name of all the buildings with a capacity of above 3000 people.
Task 9 Write a query to increase the rent of all apartments by 2% for all the apartments of Ocean Blue.
Task 10 Write a query to display all the details of the apartments owned by Owner_ID ‘2003’.
Task 11 Write a query to display all the unique Building_Locations.
Task 12 Write a query to display Building_Name and Built_Year for all buildings built in 2001.
Task 13 Write a query to display the list of all the Builidng_Names with Buiding_capacity in the range of 1000 – 2000 people in descending order.
Task 14 Write a query to display the total number of apartments in the Apartment table.
Task 15 Write a query to display the Owner_ID and the total number of apartments owned by each owner in ascending order.
Task 16 Write a query to delete the record of the owners whose Owner_Fname contains the word ‘James’.
Task 17 Write a query to display all the apartments owned by the Owner ‘Hazel’ as the Owner_Fname.
Task 18 Write a query to display all the apartment details and their corresponding Building_Names.
Task 19 Write a query to display all the apartment details in Building ‘Ocean Blue’.
Task 20 Write a query to display all the building names having more than 5 apartments along with total count of apartments for each building displayed.
Task 21 Write a query to display Owner_ID and Owner_Fname of all the owners who do not own any apartments.
Task 22 Write a query to display the building name, which has the apartment with the lowest weekly rent.
Task 23 Write a query to display all the Apartment_IDs, Apartment_Rent and their owner names of the apartments, which has a rent greater than 600 per week ordered in descending order by owner name.
Task 24 Write a query to display the details of all apartments including the Apartment_ID, Apartment_Rent, associated building name and owner details.
Submission Requirements and Instructions
This assessment comprises of TWO parts.
PART I
Requirements: Complete all the SQL tasks given in the table above. After completing the SQL tasks, you are required produce and experience/reflection report (1000 words) in a word document summarizing your experience of doing these tasks.
Submission: Your submission must composed of the following files, which must be submitted to Blackboard on or before Week 7, Thursday 23:59 (Sydney time)
1. SQL file (24 tasks) with results and outputs in a word document.
2. Experience/Reflection report.
Note: On the following day, you will receive another student’s assignment via email to review, for which you are required to write a short critique. This is explained in the following section.

StudyAcer
Calculate your paper price
Pages (550 words)
Approximate price: -
StudyAcer

Quality Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

StudyAcer

Qualified Writers

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

StudyAcer

Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account.

StudyAcer

Prompt Delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. We will always strive to deliver on time.

StudyAcer

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text.

StudyAcer

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

StudyAcer

Place your order

Fill in the order form and provide all details of your assignment.

StudyAcer

Proceed with the payment

Choose the payment system that suits you most.

StudyAcer

Receive the final file

Once your paper is ready, we will email it to you.

Academic Writing Services

If you are looking for exceptional academic writing services, then you are in the right place. Studyacer offers customised academic assignments and academic papers for students at all levels.

StudyAcer StudyAcer

Essays

Essay Writing Help

Writing an essay can be a challenge. However, we know what every student needs. And we purpose to deliver. Here at StudyAcer, we do all we can to help with academic essays and assignments. We have a dedicated team of professional essay writers.

StudyAcer StudyAcer

Assignment

Assignment Help

We understand students need satisfactory results. Our cheap assignment writing service helps and never leaves any doubt. We always strive to ensure the ultimate and best results. It is our joy to offer a cheap reliable essay writing service.

StudyAcer StudyAcer

Term paper

Term Paper Help

Have you been asking yourself, where can get a pre written research papers for sale? Worry no more, the fact that you have a term paper that is due tonight and you haven’t touched it. At Study Acer it is our responsibility to get your paper on time.

StudyAcer StudyAcer

Dissertation

Dissertation Writing Service

Several master’s students seek professional help with their thesis.Students from different parts of the world experience different challenges. Dissertations have different stages and the challenges are different too. Do not struggle in silence, order now .