DigitalArts is a video gaming service that offers subscription-based access to online video games. You need to analyze sales performance. a. Create a star schema model for the data that will allow you to compare revenue subscription counts by age groups. Indicate which tables are the fact, the what, and the occurs tables. Show the table relationship and their cardinalities. Provide at least three examples of columns for each table. Provide a example of a calculated column and an example of a measure. b. Define the algorithm for the calculated column in your example. What information modeling pattern is used for this column? c. Define the algorithm for the measure in your example. What information modeling pattern is used for this measure? Upload an Excel or zip file that contains your algorithm and a star schema. (Zip is required if you choose to use Power BI or Tableau.) Provide clear comments regarding the software used and the location within the Excel, PowerBI or Tableau file where your visualization is presented.

DigitalArts is a video gaming service that offers subscription-based access to online video games. You need to analyze sales performance. a. Create a star schema model for the data that will allow you to compare revenue subscription counts by age groups. Indicate which tables are the fact, the what, and the occurs tables. Show the table relationship and their cardinalities. Provide at least three examples of columns for each table. Provide a example of a calculated column and an example of a measure. b. Define the algorithm for the calculated column in your example. What information modeling pattern is used for this column? c. Define the algorithm for the measure in your example. What information modeling pattern is used for this measure? Upload an Excel or zip file that contains your algorithm and a star schema. (Zip is required if you choose to use Power BI or Tableau.) Provide clear comments regarding the software used and the location within the Excel, PowerBI or Tableau file where your visualization is presented.

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter8: Advanced Sql

Section: Chapter Questions

Problem 18RQ

See similar textbooks

Similar questions

Instructions: Create a dimensional model for a particular business process involving gym membership. A customer can sign up for a membership of say one, three, six or twelve months. I want to make it easy to query to identify current members, members who expired in the last month, members who renewed in the last month, those who are pending expiry etc. If I have a basic model with a fact table representing a gym membership say start_date_key end_date_key membership_attribute_key customer_atrribute_key fee with associated dimension table for date, membership attributes such as length, customer attributes and so forth. On a particular day, the active members are those with a start date before the day and an end date after that day. Those who will expire next month are those where the end date is in a particular date range.
please improe this writing: There is a big difference between time it takes to perform each of the queries. After adding primary key to each table, the time to perform each of the queries was faster than what it was before. Creating a primary key help identify unique data. Primary key in a table is a crucial column used in queries, optimized for fast performance with an associated index. The primary key index is the most efficient access path for a table. They are created after a table is created, optimizing search speed. Once constructed, indexes are internal structures that the user cannot actively access. If the internal query optimization procedure concludes that using an index will increase search efficiency, then it will be employed. When SQL queries are internally ready for execution, they automatically undergo optimization. The best way to run each query is determined by the optimization process, which may or may not include using a relevant index. Read and write speeds are…
T Shirt Sales t-shirt price quantity sold total revenue $15 400 $6,000 50 100 150 200 250 300 350 400 $10 $15 $17 $25
Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services. Create a sample list of owners and properties. Your list will be similar in structure to that in Figure 1-34 g, but it will concern owners and properties rather than owners and pets. Your list should include, at a minimum, owner name, phone, and billing address, as well as property name, type, and address. B. Describe modification problems that are likely to occur if Garden Glory attempts to maintain the list in a spreadsheet. C. Split the list into tables such that each has only one theme. Create appropriate…
Write the MySql Queries. Proving yourself worthy of being able to handle bigger tasks, the tech lead has decided to give you a challenging job. However, this time, the data that you would be handling is very sensitive and no one wants this data to be leaked. Therefore, instead of getting the entire table, the tech lead has given you the list of attributes that the table contains and the table name. The information given is as follows: You are tasked with building the MySql queries to retrieve the following information: 1. Find the first_name, last_name, email, phone_number, hire_date, and department_id of all the employees with the latest hire_date. 2. Find the first_name, last_name, employee_id, phone_number, salary and department_id of all the employees with the lowest salary in each department. 3. Find the first_name, last_name, employee_id, commission_pct and department_id of all the employees in the department 'DPT007' who have a lower commission_pct than all of the…
Create a Star Schema ERD for the Bob’s Fixit case study. Create the tables (create table DDL) from your Star Schema ERD. Bob would like to know the following: The bid dollar amount by the customer zip code and customer state. The bid dollar amount by the bid month and bid year.
Study the scenario and complete the question(s) that follow: A vet clinic "XYZ Vets" has a website with registration and login pages for its clients. The registration form contains standard registration details such as client name and surname, phone number, email address and password. You have been asked to create the relevant SQL table. The data collected should be stored and validated such that only properly authenticated clients would be granted access to the vet appointment booking page. You are not required to create the vet appointment booking page. However, you are required to verify successful authentication. With the use of MYSQL: 4.1 Create a relevant SQL table for storing the data. 4.2 Store the registration details. 4.3 Authenticate clients. 4.4 Upon successful authentication of clients, display relevant client information with a personalised message.
Murach's SQL Server 2019 for Developers Create an Entity Relationship diagram using Visio or visual-paradigm or Lucidchart or other sources. You will look at page 313 of your textbook and recreate the middle example that includes the Employees, Membership, and Committees tables.
Question p .Using Publisher ID as the common field, create a one-to-many relationship between the Publishers table and the Student Papers table. Enforce referential integrity and enable both cascade options. Create a relationship report with normal margins, and then save the report as Relationships Report. Close all open objects. Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
Your department is interested in keeping track of crucial information. Create a data structure that will keep important information for your department. Of course, the list of majors should be sorted by last name (and then by first, if there are multiple students with the same last name).Your department is interested in keeping track of crucial information. Create a data structure that will keep important information for your department. Of course, the list of majors should be sorted by last name (and then by first, if there are multiple students with the same last name).
WORKING IN CENGAGE AND CAN'T FIGURE OUT THIS TASK. I TRIED OTHER STAEMENTS BUT DID NOT WORK EITHER. PLEASE HELP! Task 5: The marketing team wants to celebrate the success of StayWell with a party. The team wants a table with the names of all residents and owners combined into single column named PARTICIPANT. You need to combine this information from the tables and send it back to the team. You do not need to create a new table in the database schema. To combine strings into a single column you must use the CONCAT function which combines two or more strings together and its syntax is the following: CONCAT(string1, string2, ....)
Within this database, you will be using tables throughout entire model, and pick the appropriate tables for each question for this assignment. Based on assignment readings and slides, perform each of the following queries from the fil table. Guided Queries: For the 5 following questions, your submission will be the query that you would write that would return the needed result Write a query that returns the Staff ID for the staff member who is involved in the most rentals. Write a query that returns all the distinct list of film category names. Write a query that counts the rentals of films, by category, and returns the category name and count of rentals. Write a query that returns the First_Name and Last_Name of each actor, and the count of the number of times their films have been rented. Write a query that returns the First_Name and Last_Name of the actor, and the count of the number of time their film has been rented, of the actor with the most rentals

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781305971776

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science