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...
-
A reasonable approximation for the two-dimensional incompressible laminar boundary layer on the flat surface in Fig P4.17 is u = U (2y/∂ - y2/∂2) for y Where ∂ ≈ Cx 1/2 , C =...
-
How many signals would be present in the 1H NMR spectrum of each of the cyclopropane derivatives shown below? Consider carefully the geometric environments around each hydrogen. (a) (b) (c) (d) (e)...
-
A meteorologist uses a Pitot-static tube to measure the wind speed in a tornado. Based on the damage caused by the storm, the tornado is rated as EF5 on the Enhanced Fujita Scale. This means that the...
-
In the bleachers. Youre a prince, George! Mike exclaimed. Who else would give me a ticket to the big game? No one, Mike, no one. Let me offer my thanks. Ill buy you a beer! Ah, George said. A large...
-
Project: Parole: Are We Better Off Without It? As you learned in this lesson, federal parole was eliminated in 1984. This made a dramatic impact on the incarceration system in the United States....
-
Barry Bird opened the Barry Bird Basketball Camp for children ages 10 through 18. Campers typically register for one week in June or July, arriving on Sunday and returning home the following...
-
Question 5. (This question has three sub-questions: (a), (b) and (c)) (a) From the figure below, as per the proposition of Modigliani and Miller -2, explain the relationship between cost of debt and...
-
What are the six operational activity forecasts necessary for determining future facility requirements?
-
Ibuprofen breaks down in the human body (decreases) at a rate of 9% per hour. The exact half life is 7.35. If you take 400mg of this medication on Tuesday at 3pm, how much will u have in ur...
-
What is the responbility of the internal and external when it comes to the clinical service: hospital death rate from a heat attack?
-
What excel spreadsheet template should I use for an insurance Claim Status Summary report?
-
What happened in my workplace is that the manager was forgot to forward an email that had the date and time the auditors were coming to the department when she was on sick-leave. The auditors arrived...
-
Let {a} be a decreasing sequence and a 0 and lima, = 0. For each ne N, b = 00 (-1)" b, diverges n-1 (-1)" b, converges 71-1 lim (b b - b) = lim 12-0 b + b + b3 +...+ b ...+ b n =1 a + a +...+ an n...
-
Trade credit from suppliers is a very costly source of funds when discounts are lost. Explain why many firms rely on this source of funds to finance their temporary working capital.
-
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,...
-
With reference to Exercise 11.6, find (a) a \(90\%\) confidence interval for the average number of classes attended each day by a student present for 15 days; (b) \(90 \%\) limits of prediction for...
-
Explain briefly the auditor's duty when (s)he has unresolved doubts about the ability of the auditee to continue as a going concern.
-
With reference to the preceding exercise, test the null hypothesis \(\beta=0.75\) against the alternative hypothesis \(\beta <0.75\) at the 0.10 level of significance.
Study smarter with the SolutionInn App