Database Design and SQL Assignment: Sales and Marketing System Design

This assignment presents a comprehensive exploration of database design and SQL. It begins with the creation of an Entity-Relationship Diagram (ERD) using MS Word, followed by the design of a sales and marketing management database system. The solution details the creation of tables for customers, products, sales, delivery, management, marketing, and departments, along with the insertion of sample data and SQL queries to retrieve and manipulate this data. The assignment also includes the creation of forms in MS Access to interact with the database. Furthermore, the solution incorporates the analysis of two datasets: one on GLA grants data and another on community services in NSW, Australia, involving the generation of pivot charts to visualize the data. This assignment showcases practical database design, SQL implementation, and data analysis skills.