Data Analysis and Design Report: Hot Property Database System Analysis

This report provides a comprehensive analysis of data analysis and database design, focusing on the development of a relational database system for the company 'Hot Property', a small estate agent business. It begins with an introduction that highlights the importance of database management in modern organizations. The report explores the comparison between data models and schemas, detailing the different types of data models (hierarchal, relational, and network) and schemas (logical, physical, and conceptual). It also discusses the benefits and limitations of various database technologies, such as data consistency, data sharing, and security, alongside challenges like maintenance costs and data redundancy. Furthermore, the report outlines different approaches to database design (top-down and bottom-up) and includes the design of a relational database for Hot Property. The assignment covers the use of SQL queries, user interface enhancement techniques, and critically reviews the developed relational database system, including user documentation, verification, and validation of database tables. Screenshots of SQL queries linked to MS Access are also provided. The report concludes with a critical assessment of the database system and its implementation, providing a detailed overview of database design principles and practical implementation.