Databases And Business Intelligence - Sales- Purchase - Stock Database System - Databases And Business Intelligence Assignment Help

Internal Code: 1AJICJ

Databases And Business Intelligence Assignment Help

TASK1 Write all the SQL statements, necessary to create all tables and relationships, with Primary & Foreign keys. Execute each statement in the correct order so as to create the relational database in MYSQL Insert some data into each table Use all your SQL create and Insert statements (from MS Word) to execute in the MYSQL WorkBench Write in MS Word and execute in MYSQL WorkBench the statements necessary to; Display all tables, identify stock levels for items, identify customer total expenditure TASK2 Dataset details: The URL of the dataset. A description of the dataset. A screen capture showing the first page of the Excel spreadsheet containing the dataset. Screen captures of ONE pivot table analysis on the dataset utilised together with ONE chart output that you have created. A clear written analysis of your findings from the pivot table and chart. Focus on the insight you are trying to gain and the business intelligence you derive Try differentiating dimensions from facts in the dataset. You will usually have dimensions as the rows (time, location, product type) and facts in the centre (revenue, cost etc).