Describe how to identify and interpret transaction management, concurrency control concepts, and interpret business intelligence and data warehousing/mining concepts.
Added by Joaquin I.
Step 1
- Identify the properties of transactions using the ACID principles (Atomicity, Consistency, Isolation, Durability). - Recognize the importance of transaction management in ensuring data integrity and reliability. Show more…
Show all steps
Your feedback will help us improve your experience
Adi S and 58 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
1. Using an example to describe the process of data mining. Your example is to think of a SMALL business and what data it uses and describe how you would perform data mining on the data (5 Marks) 2. Data warehouse and data mart are architecturally different as we know. Discuss these architectural differences. You must show in your answers one example of a data warehouse and one of data mart. (5 Marks) 3. What are the major design principles of security architecture that need to be adhered to in the creation and operation of a data warehouse? (5 Marks) 4. How are descriptive analytics and predictive analytics related? Report on what each does and, on their relationship(s). (5 Marks) 5. the Apriori algorithm is the most commonly used algorithm to discover associations rules. Based on this and using the table below to analyse the below table. You must follow the step-by-step approach we followed during the lectures to list the rules that are accepted or rejected. Hint: As you should know you have to calculate the support and confidence when creating the tables and Functions Transactions ID Items bought in a Transaction Trans. 1 B, E, W Trans .2 B, T, W Trans. 3 E, M Trans. 4 M, B, W Trans. 5 B, E, W, T Note: B is Beef, E is Eggs, W is wine, M is Margarine, T is Toast
Adi S.
It is important that you specify your name in the assignment document/attachment: Your submitted files should contain one SQL file for part 1, and a DTSX file part 2. If you use Flat File or Excel Data Source for Part 2, please include the file also. It is important that you specify your name in the assignment document/attachment: The attachment name should follow the following convention for Part I: BUSAS32_MIDTERM_FIRSTNAME_LASTNAME PART1.SQL The attachment name should follow the following convention for Part II: BUSA532_MIDTERM_FIRSTNAME_LASTNAME PART2.DTSX PART I: Use Adventure Work OLTP logical schema to build data warehouse tables in SQL: CEO of Adventure Work Inc. wants to keep track of performance of their stores. Particularly, he wants to know the total number of products produced quarterly and total number of products sold quarterly. In addition, he wants to know yearly net profit margin (calculated by using product list price divided by product standard cost). Provide 4-step dimensional model in the SQL comment section (4 points) and create data warehouse solution in SQL for the dimensional model that you propose (26 points). PART II: Use Adventure Work OLTP's Production and Sales schema to build a data warehouse consisted of two data marts. (You can find instructions to install the database in Topic 2 if you haven't installed yet). (70 points). Your database should meet these requirements: - DimDate table has DateKey values ranging from 20100304 to 20140602 (YYYYMMDD integer data type). If you use Flat File or Excel Data Source to import date key data, include the data source file in the submission also (5 points). - DimDate table should have IsMartinLutherKing (BOOLEAN data type), WeekNumberOfYear (INT data type), DayNumberOfYear (INT data type), and Quarter (INT data type) attributes (15 points). - DimProduct should contain product ID, product name, category name, discontinued, and Current Value (10 points). - Dim Product should be able to handle Type 2 SCD issues (5 points). - FactlessProductSellingTable has 2 foreign keys - SellStartDateKey and ProductKey (10 points). - SalesPerformance has 2 foreign keys - DateKey and ProductKey (10 points). - Correct ETL process to create 3 fact measures for SalesPerformance (15 points) The following table and graph show you the data description of fact measures and ERD of the data warehouse: Fact Measure | Data Description TotalProductOrdered | Total number of products ordered each day TotalProductSpecialOffer | Total amount of product special offer each day MostProductOrderedIndicator | Display Boolean value if the product was ordered the most The following criteria will be used to grade the midterm: - Codes are detailed, accurate, and SSIS solution package are correct.
Akash M.
Discuss: Business Analytics in Action, Data Visualization Part I: Data visualization - the process of displaying data (often in large quantities) in a meaningful fashion to provide insights that will support better decisions. Refer to the article describing the use of Analytics at the Cincinnati Zoo and Botanical Garden. Apply insights from the article to either Ch 3 #18 OR Ch 3 #19 (choose one). These open-ended questions have many options. Effective responses will be well-designed, including formatted charts. Please explain the reasoning for your choices.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD