Database System Analysis Assignment 2022

Running head: DATABASE SYSTEM AND ANALYSIS
SALES AND MARKETING DATABASE SYSTEM
Name of the Student
Name of the University
Author Note

DATABASE SYSTEM AND ANALYSIS1
Table of Contents
Part 1: sales and marketing management database system..............................................................2
ERD diagram...............................................................................................................................2
SQL queries.................................................................................................................................2
Display tables...............................................................................................................................4
3. Form.........................................................................................................................................9
Bibliography..................................................................................................................................13

DATABASE SYSTEM AND ANALYSIS2
Part 1: sales and marketing management database system
ERD diagram
SQL queries
INSERT INTO `sales details` (`Sales_ID`, `Date_sale`, `Sale_type`, `Payment_details`,
`ProductID`, `Customer_ID`) VALUES ('101', '2019-09-21', 'Medical', '52681900', '123456789',
'10'), ('102', '2019-09-03', 'Groccery', '277990990', '987654321', '11');
INSERT INTO `delivery details` (`Delivery_ID`, `DELIVERY_DATE`, `Sales_ID`) VALUES
('10001', '2019-09-28', '101'), ('10002', '2019-09-30', '102');

DATABASE SYSTEM AND ANALYSIS3
INSERT INTO `customer details` (`Customer_ID`, `address`, `contact_no`, `Delivery_ID`)
VALUES ('10', 'Mellbourne', '987269100', '10001'), ('11', 'South avenue', '268190100', '10002');
INSERT INTO `marketing details` (`Marketing_ID`, `Product_ID`, `Marketing_Details`)
VALUES ('009101', '123456789', 'promotion'), ('009102', '987654321', 'advertisement');
INSERT INTO `production details` (`ProductID`, `production_date`, `Production_description`)
VALUES ('123456789', '2019-09-26', 'Buiscuit'), ('987654321', '2019-09-21', 'Chocolates');
INSERT INTO `management details` (`Manage_ID`, `Sales_ID`, `Products`) VALUES ('001',
'101', 'Water'), ('002', '102', 'Rice');