Database System Design: Sales, Marketing and Business Intelligence

This document presents a comprehensive solution to a sales and marketing management database system assignment, including the design of an Entity-Relationship (ER) model, normalization of tables, and the creation of SQL statements for database creation, data insertion, and querying. The solution covers the implementation in MS Access, showcasing tables, forms, and an EER diagram. Furthermore, it delves into business intelligence, utilizing two datasets to create pivot tables and charts, followed by detailed analyses of the findings. The assignment addresses key aspects of database design, data manipulation, and analytical techniques, providing a practical approach to understanding and implementing a sales and marketing database system and business intelligence.