Database and Analytics Principles 1: Auto Sales Data Analysis

This report provides a comprehensive analysis of an auto sales database, starting with the design of a logical data model using Crow's foot notation to create an Entity-Relationship (ER) model. It details the database's entities, attributes, and relationships. The report then produces SQL scripts to create and populate database tables, including the creation of ten records for each table. Furthermore, the report critically evaluates data analytics technologies and tools like Hadoop, data warehouses, and data mining, explaining how BuyUS can leverage these to extract value. Finally, it explores the design of a star schema for the auto sales database, providing a dimensional modeling approach for effective data warehousing and analysis. The report offers insights into database design, implementation, and the application of data analytics for business intelligence.