E8.4 Consider the following scenario involving Pineview Ford, an auto dealership. Auto dealership Pineview Ford is organized as follows: • Pineview Ford keeps track of Vehicle Identification number of every vehicle that is for sale, sold, serviced, or rented by the dealership. • Vehicles are sold via a sale transaction. One transaction involves one sales person, one client, and one vehicle. • Vehicles are serviced via a service transaction. One transaction involves one service person, one client, and one vehicle. • In addition to selling and servicing vehicles, Pineview Ford occasionally rents vehicles. One rental transaction involves one rental agent, one client, and one vehicle. Pineview Ford wants to create the analytical database (data warehouse) to analyze their revenue. The two available data sources, Source 1 and Source 2, are described below. Source 1 Pineview Sales and Service Database Source 2 Pineview Rental Log The data warehouse has to enable an analysis of revenue by all relevant dimensions. (Hint, the dimensions should enable analysis by dates, vehicles, employees, clients, and types of revenue.) E8.4a Based on the sources and requirements listed above, create a dimensional model that will be used for the dimensionally modeled data warehouse for Pineview Ford.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

E8.4 Consider the following scenario involving Pineview Ford, an auto dealership.

Auto dealership Pineview Ford is organized as follows:

• Pineview Ford keeps track of Vehicle Identification number of every vehicle that is for sale, sold, serviced, or rented by the dealership.
• Vehicles are sold via a sale transaction. One transaction involves one sales person, one client, and one vehicle.
• Vehicles are serviced via a service transaction. One transaction involves one service person, one client, and one vehicle.
• In addition to selling and servicing vehicles, Pineview Ford occasionally rents vehicles. One rental transaction involves one rental agent, one client, and one vehicle.

Pineview Ford wants to create the analytical database (data warehouse) to analyze their revenue. The two available data sources, Source 1 and Source 2, are described below.

Source 1 Pineview Sales and Service Database
Source 2 Pineview Rental Log

The data warehouse has to enable an analysis of revenue by all relevant dimensions. (Hint, the dimensions should enable analysis by dates, vehicles, employees, clients, and types of revenue.)

E8.4a Based on the sources and requirements listed above, create a dimensional model that will be used for the dimensionally modeled data warehouse for Pineview Ford.

Create a dimensional Table for 8.4A.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions