Design Data warehouse schema to analyse to effect of promotion activites versus sales in different retail store of Reliance fresh and in different geographies like state district, state and region. How item sale is affected by the promotions at each store, in each state and across the entire country. Reliance fresh puts some of their products on promotional sales from time to time. There may be a large number of different types of promotions like coupon sales, end-of-the-aisle display, buy-two-get-one-free, etc. Identifying the fact table(s), dimension table(s), their attributes and measures along with the primary key and foreign key relationships.

Design Data warehouse schema to analyse to effect of promotion activites versus sales in different retail store of Reliance fresh and in different geographies like state district, state and region. How item sale is affected by the promotions at each store, in each state and across the entire country. Reliance fresh puts some of their products on promotional sales from time to time. There may be a large number of different types of promotions like coupon sales, end-of-the-aisle display, buy-two-get-one-free, etc. Identifying the fact table(s), dimension table(s), their attributes and measures along with the primary key and foreign key relationships.

Management Of Information Security

6th Edition

ISBN:9781337405713

Author:WHITMAN, Michael.

Publisher:WHITMAN, Michael.

Chapter7: Risk Management: Treating Risk

Section: Chapter Questions

Problem 1EDM

See similar textbooks

Similar questions

Design the star schema to analyses the employee salary according to their age (by year or by decade), their study level and the geographic location of the enterprise. The study level analysis can be performed according to the higher study level reached (primary, secondary school, university level) or according to the last obtained degree (primary degree, secondary degree, bachelor, master, PhD). The geographic enterprise location analysis can be conducted by city, region, or country
An online warehouse provides features for their customers to browse and search products and to place orders for these products online. Figures below are interaction diagrams for use case ‘search product’ (Figure 1) and use case ‘place an order’ (Figure 2). b) Suggest an architecture for this system. Provide justification for your proposal. Include diagrams to support your answer. c) Explain at least TWO (2) quality attributes that the proposed architecture will satisfy.
You are required to create a conceptual data model of the data requirements of the company that specializes in IT training. The company has 30 instructors and could handle up to 100 trainees per training session. The offers five advanced technology courses, each of which is taught by a teaching team of two or more instructors . Each instructor is assigned to a maximum of two teaching teams or may be assigned to do research. Each trainee undertakes one advanced technology course per training session. Identify the main relationship types and specify the multiplicity for each relationship. State any assumptions you make about data.
A manufacturing company produces products. The following product information is stored: product name, product ID and quantity on hand. These products are made up of many components. One or more suppliers can supply each component. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used. Create an ERD to show how you would track this information. Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality. Assumptions: A supplier can exist without providing components. A component does not have to be associated with a supplier. A component does not have to be associated with a product. Not all components are used in products. A product cannot exist without components.
Accounting staff utilizing an enterprise resource planning (ERP) system talk about "data flows" between different modules. The accountants need you to break out why they aren't being specific and show them what words they should be using instead.
A. Draw an E-R data model for the Highline University Mentor Program Information System (MPIS). Use the IE Crow’s Foot E-R model for your E-R diagrams. Justify the decisions you make regarding minimum and maximum cardinalities. Your model should track students, advisers, and mentors. Additionally, Highline University needs to track alumni because the program administrators view alumni as potential mentors.1. Create separate entities for students, alumni, faculty advisers, and mentors. • At Highline University, all students are required to live on campus and are assigned Highline University ID numbers and email accounts in the format FirstName. LastName@students.hu.edu. The student entity should track student last name, student first name, student University ID number, student email address, dorm name, dorm room number, and dorm phone number.a.At Highline University, all faculty advisers have on-campus offices and are assigned Highline University ID numbers and email accounts in the…
You're required to create a conceptual data model of the data requirements of the company that specializes in IT training. The company has 30 instructors and could handle up to 100 trainees per training session. The offers five advanced technology courses, each of which is taught by a teaching team of two or more instructors . Each instructor is assigned to a maximum of two teaching teams or may be assigned to do research . Each trainee undertakes one advanced technology course per training session. Identify the main types of the company
Create an ER Diagram of hospital and explain why each entity, attribute and relationship are used in the ER diagram
A large metropolitan city supports several orchestras. Each orchestra has many musicians and each musician can play at different orchestras. All the musicians are specialists and play only one instrument (e.g., harp, violin, viola, cello, etc.). A specific instrument can be played by multiple musicians. Identify several attributes and a key field for each entity. Represent this situation with an E-R diagram
Draw an EER diagram for the following situation using the traditional EER notation. A technology company provides offerings to its customers. Offerings are of two separate types: products and services. Offerings are identified by an offering ID and an attribute of description. In addition, products are described by product name, standard price, and date of first release; services are described by name of the company’s unit responsible for the service and conditions of service. There are repair, maintenance, and other types of services. A repair service has a cost and is the repair of some product; a maintenance service has an hourly rate. Fortunately, some products never require repair. However, there are many potential repair services for a product. A customer may purchase an offering, and the company needs to keep track of when the offering was purchased and the contact person for that offering with the customer. Unfortunately, not all offerings are purchased. Customers are…
Accountants at a firm that uses an ERP system speak about "data flows" between modules. Explain the accountants' lack of specificity and provide a better phrase for them to use.
Create an Entity Relationship diagram that captures the information about the UPS system? Be certain to indicate identifiers and cardinality constraints. UPS prides itself on having up-to-date information on the processing and current location of each shipped item. To do this, UPS relies on a company-wide information system. Shipped items are the heart of the UPS product tracking information system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the UPS system at a single retail center. Retail centers are characterized by their type, uniqueID, and address. Shipped items make their way to their destination via one or more standard UPS transportation events (i.e., flights, truck deliveries). These transportation events are characterized by a unique scheduleNumber, a type (e.g, flight, truck), and a deliveryRoute.