Database System and Analysis Assignment: Sales and Marketing

This assignment focuses on a sales and marketing database system. It begins with an ERD diagram illustrating the relationships between entities such as sales details, delivery details, customer details, marketing details, production details, and management details. The solution includes SQL queries for inserting data into various tables like `sales details`, `delivery details`, `customer details`, `marketing details`, `production details`, and `management details`. Display tables are also provided demonstrating data retrieval. Additionally, the assignment showcases examples of SQL queries for data analysis, such as calculating the sum of sales based on product description and selecting specific data based on status. The assignment concludes with a bibliography of relevant research papers on database design and analysis.