Create and insert an ERD showing the constellation ERD schema below. Please see requirements in the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create and insert an ERD showing the constellation ERD schema below. Please see requirements in the next two sections. Determine four to five (non-date/time) dimension tables a. SCDs need to be considered- make sure to include at least one type 2 and one type 3 Consider the date dimensions of different grains, consider a role-playing or bitemporal dimension, if so, explain why this is the case. b. c. For EACH table answer the following question: What kind of SCD is the dimension table and why did you choose this type of SCD? Determine two to three fact tables a. How are the measures tied to your questions? b. Explain if your fact tables cumulative or snapshot C. Which attributes might be degenerative in your fact tables? d. Which attributes in the OLTP schema will transform to measures? e. What measures can be derived/calculated that should be included? Bike Type PK bike_type_id int NOT NULL bike_type varchar(30) Bike Brand PK bike brand id int NOT NULL bike_brand varchar(30) Part_Type PK part type id int NOT NULL part_type varchar(30) PK bike id int NOT NULL OFK bike_type_id int NOT NULL -OFK bike_brand int NOT NULL Bike tire_size int tire_type varchar(40) bike_color varchar(40) Employee PK employee id int NOT NULL last_name varchar(50) NOT NULL first_name varchar(30) NOT NULL Specialty varchar(50) Role varchar(50) Part PK part id int NOT NULL part_name varchar(50) NOT NULL OFK part_type_id INT part vendor varchar(50) unit_cost numeric Service PK service_ld int NOT NULL FK customer_id int NOT NULL FK bike_id int NOT NULL service_start_Date Time timestamp service_end_Date Time timestamp total_service_price numeric Service_Line PK service line Id int NOT NULL FK service_id int NOT NULL FK service_type_ID int NOT NULL FK employee_id int NOT NULL labor_cost numeric Service Part PK/FK service_line_Id int NOT NULL PK/FK part id int NOT NULL part_count int part_cost_at_service numeric Customer PK customer_id int NOT NULL last_name varchar(50) NOT NULL first_name varchar(30) NOT NULL phone varchar(30) NOT NULL email varchar(50) NOT NULL FK address_id int Address PK address id int NOT NULL AddressLine1 varchar(60) AddressLine2 varchar(60) City varchar(60) State ZipCode varchar(15) Service Type PK service type id int NOT NULL service Type_Name varchar(50) External Weather data is to come via an API such as https://openweathermap.org Here is a sample JSON API response to give you a sense of the data returned: https://openweathermap.org/current#current_JSON wwwm { "coord": { "lon": 10.99, "lat": 44.34 }, "weather": [ { "id": 501, "main": "Rain", "description": "moderate rain", "icon": "10d" } ], "base": "stations", "main": { "temp": 298.48, "feels like": 298.74, "temp min": 297.56, "temp max": 300.05, "pressure": 1015, "humidity": 64, "sea level": 1015, "grnd level": 933 }, "visibility": 10000, "wind": { "speed": 0.62, "deg": 349, "gust": 1.18 }, "rain": { "1h": 3.16 }, "clouds": { "all": 100 }, "dt": 1661870592, "sys": { "type": 2, "id": 2075663, "country": "IT", "sunrise": 1661834187, "sunset": 1661882248 }, "timezone": 7200, "id": 3163858, "name": "Zocca", "cod": 200 } winnaam شش Create and insert an ERD showing the constellation ERD schema below. Please see requirements in the next two sections. Determine four to five (non-date/time) dimension tables a. SCDs need to be considered- make sure to include at least one type 2 and one type 3 Consider the date dimensions of different grains, consider a role-playing or bitemporal dimension, if so, explain why this is the case. b. c. For EACH table answer the following question: What kind of SCD is the dimension table and why did you choose this type of SCD? Determine two to three fact tables a. How are the measures tied to your questions? b. Explain if your fact tables cumulative or snapshot C. Which attributes might be degenerative in your fact tables? d. Which attributes in the OLTP schema will transform to measures? e. What measures can be derived/calculated that should be included? Bike Type PK bike_type_id int NOT NULL bike_type varchar(30) Bike Brand PK bike brand id int NOT NULL bike_brand varchar(30) Part_Type PK part type id int NOT NULL part_type varchar(30) PK bike id int NOT NULL OFK bike_type_id int NOT NULL -OFK bike_brand int NOT NULL Bike tire_size int tire_type varchar(40) bike_color varchar(40) Employee PK employee id int NOT NULL last_name varchar(50) NOT NULL first_name varchar(30) NOT NULL Specialty varchar(50) Role varchar(50) Part PK part id int NOT NULL part_name varchar(50) NOT NULL OFK part_type_id INT part vendor varchar(50) unit_cost numeric Service PK service_ld int NOT NULL FK customer_id int NOT NULL FK bike_id int NOT NULL service_start_Date Time timestamp service_end_Date Time timestamp total_service_price numeric Service_Line PK service line Id int NOT NULL FK service_id int NOT NULL FK service_type_ID int NOT NULL FK employee_id int NOT NULL labor_cost numeric Service Part PK/FK service_line_Id int NOT NULL PK/FK part id int NOT NULL part_count int part_cost_at_service numeric Customer PK customer_id int NOT NULL last_name varchar(50) NOT NULL first_name varchar(30) NOT NULL phone varchar(30) NOT NULL email varchar(50) NOT NULL FK address_id int Address PK address id int NOT NULL AddressLine1 varchar(60) AddressLine2 varchar(60) City varchar(60) State ZipCode varchar(15) Service Type PK service type id int NOT NULL service Type_Name varchar(50) External Weather data is to come via an API such as https://openweathermap.org Here is a sample JSON API response to give you a sense of the data returned: https://openweathermap.org/current#current_JSON wwwm { "coord": { "lon": 10.99, "lat": 44.34 }, "weather": [ { "id": 501, "main": "Rain", "description": "moderate rain", "icon": "10d" } ], "base": "stations", "main": { "temp": 298.48, "feels like": 298.74, "temp min": 297.56, "temp max": 300.05, "pressure": 1015, "humidity": 64, "sea level": 1015, "grnd level": 933 }, "visibility": 10000, "wind": { "speed": 0.62, "deg": 349, "gust": 1.18 }, "rain": { "1h": 3.16 }, "clouds": { "all": 100 }, "dt": 1661870592, "sys": { "type": 2, "id": 2075663, "country": "IT", "sunrise": 1661834187, "sunset": 1661882248 }, "timezone": 7200, "id": 3163858, "name": "Zocca", "cod": 200 } winnaam شش
Expert Answer:
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these databases questions
-
Can an importer reject goods that are not satisfactory, even though the goods have been paid for before receipt? Please explain your opinion in detail.
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Seawall Corporation uses an injection molding machine to make a plastic product, Z39, after receiving firm orders from its customers. Seawall estimates that it will receive 50 orders for Z39...
-
Consider the electronic inverter data in Exercise 12-66 and 12-67. Define the response and regressors variables as in Exercise 12-67, and delete the second observation in the sample. (a) Use all...
-
Review Apple's and Microsoft's 10-K for the fiscal year 2023. Use the information to answer the following: 1. Explain at least two reasons for the difference in ROE between the two companies. What...
-
An indirect way of measuring of secondary emission from ponds or large bodies of water used in waste treatment is to measure the concentration and velocity over the surface. The data can then be...
-
T. L. Jones Trucking Services establishes a petty cash fund on April 3 for$500. By the end of April, the fund has a cash balance of $32 and has receipts for the following items: Utilities...
-
The Smith family is moving to Little Rock because of a job relocation. They decide to purchase a home near Ms. Smith's office which is in a part of town that was established in the mid-1980's. When...
-
1. Estimate the demand for soft drinks using a multiple regression program available on your computer. 2. Interpret the coefficients and calculate the price elasticity of soft drink demand. 3. Omit...
-
19. Which of the following statements concerning CPM activities is false? Select one: a. The late finish is the earliest of the late start times of all successor activities. b. The early finish of an...
-
3. Suppose that g is given by the graph at left in Figure 5.3 and that A is the corresponding integral function defined by A(x) = g(1) dt. 3+ 6 MA -10 3+ Mat 3 5 Figure 5.3: At left, the graph of y=...
-
Consider the following network. Don't forget to explain rationales behind your answer. 2 3 5 8 (a) What is the diameter of the network? (b) What is the node connectivity between node 3 and node 9?...
-
SJM Group contacts one of their largest customers, Soren Corp, because they have not yet made payment on their account (Soren Corp had previously received advertising services from SJM Group on...
-
2. Compute the magnitude of the tangent vector and the unit tangent vector at t = 1 for each of the following vector functions. Provide a sketch of the curve from t=0 to t = 1. (a) r(t) = (t,...
-
Tiger Company Limited's total assets are valued at $3,000,000 and currently 20% is financed by debt while 80% is from equity. The company hired a financial consultant to determine the optimal debt to...
-
A combination of personnel, records, and procedures that a business uses to provide financial data is known as A. output B. source documents OC. an accounting information system OD. input
-
Which of the following streaming TV devices does not involve use of a remote controller? A) Google Chromecast B) Apple TV C) Amazon Fire TV D) Roku
-
For each of the following pairs of related entities, indicate whether (under typical circumstances) there is a one-to-many or a many-to-many relationship. Then, using the shorthand notation...
-
Match the following terms to the appropriate definitions: _______ Hive a. knowledge discovery using a variety of statistical and computational techniques _______ Text mining b. analytics that...
-
Visit www.teradatauniversitynetwork.comand download the dimensional modeling tool located under the downloadable software section. Use this tool to draw your answers to Problems and Exercises 9-28,...
-
Find the probability of an IQ less than 85.
-
If 25 women are randomly selected, find the probability that the mean of their red blood cell counts is less than 4.444. Assume that red blood cell counts of women are normally distributed with a...
-
Mensa International calls itself the international high IQ society, and it has more than 100,000 members. Mensa states that candidates for membership of Mensa must achieve a score at or above the...
Study smarter with the SolutionInn App