The Trade Master company sells various tools. It has sales offices and warehouses all over Australia. The company developed a data warehouse to store information about sales, customers and products. These data are stored in the AppliedProject2 Access file provided for you.
The database consists of 6 tables:
• CompanyDim — with the sales office address, state and email • ProductDim — product information • WarehouseDim — warehouse locations • CustomerDim — information about customers • DateDim — sales dates • SaleFacts — information about sales
Please notice that all data (customers, sales, dates, warehouses and products) are randomly generated. Table and field names are self-explanatory.
The Global Trading company wants to retrieve information from the database for reporting and data analysis.
You must do the following tasks
- In the MS Word document: a. Analyse and describe the tables. b. Describe dimension and fact tables. (You need to remember that the database tables are organised into a fact and dimension tables, and this structure is called a database star schema). c. Identify and describe primary and foreign keys. d. Draw the database diagram. e. Copy from the database all queries to the Word document and explain them. 2. In the MS Access database, you need to write, save and run the following SQL queries: a. Create all primary and foreign keys. b. Insert a new customer. Devise your own data for this record. c. Create a new sale fact related to the new customer. You can choose any existing product, warehouse, date and sales office. d. Display all customer names, their addresses and states. e. Display all customer names from NSW. f. Display the total amount of all company sales in 2018.
PORTFOLIO PART A Topic 1: Sustainability and Marketing today Question 1: Provide some background information about your chosen company. Question 2: From a theoretical perspective (and in your own words) explain what is meant by Sustainability and Sustainable Marketing. Question 3: Outline the Sustainability Strategy for your organisation and discuss current sustainability initiatives.
Topic 2: The Marketing Environment Question 1: From a theoretical perspective (and in your own words) outline the different types of macro-environmental forces that impact an organisation. Question 2: Create a PESTEL analysis for your chosen company. Question 3: How will these factors affect your organisation’s marketing planning?
PORTFOLIO PART B You must complete this task using the same company that you used for Portfolio Part A. Topic 3: Segmentation, Targeting and Positioning Question 1: From a theoretical perspective (and in your own words) outline the importance of a segmented marketing strategy. Question 2: Provide an outline and analysis of the market segment(s) that your organisation targets in their market segmentation strategy. Question 3: Outline the positioning for your brand?
Topic 4: Product Question 1: From a theoretical perspective (and in your own words) outline what is meant by the total product concept and product differentiation. Question 2: Provide an analysis of the product offering that your chosen organisation markets. Question 3: How does your chosen organisation differentiate its product(s) to obtain a competitive advantage?
PORTFOLIO PART C You must complete this task using the same company that you used for Portfolio Part A. Topic 5: The Promotion Mix Question 1: From a theoretical perspective (and in your own words) outline what is meant by The Promotion Mix. Question 2: Create a table that summarises the current Promotion Mix activities for your chosen organisation. Question 3: Discuss your thoughts on why this promotional mix is effective (or ineffective) for your company. Topic 6: The Marketing Mix Question 1: From a theoretical perspective (and in your own words) outline what is meant by The Marketing Mix. Question 2: Outline the extended marketing mix for your organisation Question 3: Create an infographic that visually represents and summarises the marketing mix for your organisation.
The post Assessment 3: Applied Project-2 appeared first on My Assignment Online.