User Account

All Pages

Design a star schema to organize the sales information

Assignment Help Database Management System
Reference no: EM131396007

Assignment

Answer to this question

A star schema is a type of data warehouse design that optimizes multidimensional query performance (Poolet, 2007).

Your reading gives a case example and a high-level overview of modeling an information system. The first step in designing an information system is to construct a data model. The data model you use is a star schema.

A large online company's marketing department needs information to examine sales, predict future directions, and determine how and what to advertise. Design a star schema to organize the sales information to meet the marketing department needs. Identify the dimensions first, and then identify the attributes of those dimensions.

Reference no: EM131396007

Questions Cloud

Describe correlation as a measure of association : Describe correlation as a measure of association.Describe different methods of establishing correlation between variables, and provide an example for each.Explain the advantages and disadvantages of each method and where each must be applied.Provide ..
Identify how cultural values affect cyber ethics norms : Identify examples of how cultural values affect moral legitimacy and cyber ethics norms. Cyber Espionage and the Theft of U.S. Intellectual Property and Technology [2013 - video / transcripts of Congressional hearing].
Write a paper to summarizing the job responsibilities : After each of the 12 paragraph pairs, note whether that specialty in psychology would be of interest to you as a career option in the future and explain why or why not. Once the 12 sets of paragraphs and interest or non-interest explanations are ..
Analyze the data with the appropriate nonparametric test : Undergraduates from Canada and the United States responded to a questionnaire on attitudes toward government regulation of business. High scores indicate a favorable attitude.- Analyze the data in the accompanying table with the appropriate nonpar..
Design a star schema to organize the sales information : Design a star schema to organize the sales information to meet the marketing department needs. Identify the dimensions first, and then identify the attributes of those dimensions.
Production costs and the business cycle : Pay particular attention to how consumer demand would change, and how the event would affect production costs and the business cycle.
China passage from theory of moral sentiments : In his essay "Adam Smith's View of Man", Ronald Coase discusses the China passage from Theory of Moral Sentiments. He observes that:
Describe the experience of creating the social media site : Then you need to write a 1-2 page paper describing the experience of creating the social media site. Discuss the benefits you see of having this service, as well as the concerns you have with it.
Comprehensive comparison of terms : Select three terms from this week's readings, and discuss how these terms compare to each other in the world of health care economics. Some examples of terms are resources, quality, technology, and costs. Write a 750- to 1,050-word paper that is a ..

Reviews

Write a Review

Database Management System Questions & Answers

  Question 1 entity-relationship er model create an er

question 1 entity-relationship er model create an er diagram using the set of requirements provided for oxford city

  Discuss how olap and data warehousing technologies

Discuss how OLAP and data warehousing technologies work together in solving user problems. What are the advantages and disadvantages of the different OLAP technologies (MOLAP, ROLAP, HOLAP)?

  Data collection procedures and data analysis techniques

Specify the approach (qualitative or quantitative), research design, sampling strategy, data collection procedures, and data analysis techniques to be used.

  Write sql statements to create the corresponding relations

Write SQL statements to create the corresponding relations to the ER diagram you designed for Exercise 2.8. If your translation cannot capture any constraints in the ER diagram, explain why.

  Imagine that you have been hired as a consultant to assist

imagine that you have been hired as a consultant to assist in streamlining the data processing of an international

  Create a role for user to complete imports & exports of data

Use the DTS utility to Import the data from the text file into your SQL Server database. Show screen shots of the import steps and provide a screen shot of the table rows in the Enterprise Manager once the data is imported.

  Write pseudo code for make-set find-set and union

Write pseudo code for MAKE-SET, FIND-SET, and UNION using the linked-list representation and the weighted-union heuristic. Make sure to specify the attributes that you assume for set objects and list objects.

  Where can sub queries be placed in a sql select statement

Where can sub queries be placed in a SQL select statement? What tables are good candidates for indexes and what type of indexes would you place on those tables? What type of data model is used in data marts to improve performance?

  Plot the data on a scatter plot

Plot the data on a scatter plot. Determine the ideal number of clusters. Choose random center points (centroids) for each cluster. Using a standard distance formula measure the distance from each data point to each center point.

  Briefly describe the modeling problem facing lbs

Briefly describe the modeling problem facing LBS, and identify what type of problem it is in terms of the types of data mining problems discussed in session

  Create and print a select query that lists the book title

Create and PRINT a select query that lists the book title and List Price for all book title startwith Life. Save this query as KellyCaseC before you print it

  Create a schema that supports the company business

Create a schema that supports the company's business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd