MIS201- Database Fundamentals - Programming Project

Assignment Task

Summary

In this group assessment, you are required to read the case scenario provided and complete a number of database programming tasks. These tasks require you to create database and tables, and to manipulate, delete and query data.

Context

This Database Programming Project focuses on assessing your SQL programming skills. By completing this assessment, you will demonstrate your understanding of the following topics: - SQL data definition and data manipulation statements and - Select query statements, as well as your ability to write correct and efficient SQL statements to solve problems in a close-toreal-life scenario.

Task

1. Write MySQL statements to create a database called ’ABC_REAL_ESTATE ‘and the six database tables as shown in the case study. You need to choose the most appropriate attribute type for each attribute. The database table design will also minimise the likelihood of data anomalies.
2. Write MySQL statements to insert at least five (5) rows into these four tables:. You may make up the data to be inserted into those tables; however, you must maintain the data integrity of this database. Tasks 3 -10 Please note that when you perform the tasks 3. You may need to add, delete or update records to test and produce the the desired result.

3. Due to increase in demand of properties in SA, it has been decided that the listed price of all SA properties that are currently listed (not under offer, contracted or settled) will be increased by 10%. Write one (1) MySQL statement to reflect this change.

4. The vendor of the property under property ID ’23’ is in the market for too long, and the vendor feels that property needs to undergo some renovations to bring it back to the market again. Write a MySQL statement to update the property status of the property to ‘off market’.

5. The Real Estate management would like to receive a list of properties which have been sold in the last quarter, July 2021 to September 2021 (inclusive). Write one MySQL query statement to select Assessment 3, MIS201 Page 3 of 7 property information to show this information. Your query should return a table in the following format.

This MIS201- IT and Computer Science has been solved by our IT Computer Science experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.