This document presents a comprehensive solution to a Database Fundamentals 1 assignment, focusing on the design and implementation of a database for a national real estate agency, ABC Real Estate. The assignment involves creating tables for properties, vendors, agents, and purchases using MySQL. It includes SQL statements for table creation, data insertion, updates, deletions, and various SELECT queries. The solution covers tasks such as creating tables with appropriate data types, inserting sample data, updating property statuses, and retrieving information based on specific criteria, including filtering by state, type, and sale price. Furthermore, the solution demonstrates the use of JOIN operations to retrieve data from multiple tables, such as agents and purchases, and vendors and properties, to calculate averages, counts, and identify specific records based on conditions like contract and settlement dates. The assignment showcases the practical application of database fundamentals in a real-world scenario, emphasizing data manipulation and retrieval using SQL.
![[object Object]](/_next/static/media/star-bottom.7253800d.svg)
