DBW624S1A-INTRODUCTION TO DATA WAREHOUSING-Fact Table - IT Computer Science Assignment Help

1.Build your logical model to meet the following requirements:

a. The FACT table contains rental facts. Each car rental by a customer is a record in the fact
table.

b. Each vehicle will have a Vehicle Identification Number (VIN) which uniquely identifies it

c. You must have a CARS DIMENSION table. This is where you store a record for each rental
car in your fleet

d. You must have a CUSTOMER DIMENSION table. This is where you store information on
each customer who rents a vehicle

e. You must pick FOUR additional DIMENSION tables for your logical model

f. You must have a REFERENCE table which contains Canadian postal codes

g. The actual signed rental contract will be in JSON format and must be stored with each fact.

2 The service organization needs to know what repairs need to be performed on vehicles
in between rental periods. Build a MAINTENANCE_EVENTS table which tracks information
from the sensors within a specific vehicle. Assume the car has sensors which relay the following
information. This table should track items like % of wear on break pads, tire pressure, wheel
alignment, kms since last maintenance check, fluid levels. Each sensor will have a SENSOR ID.
You’ll need a REFERENCE table which maps SENSOR IDs to VINs. Each sensor type (breaks,
alignment, fluids, tire pressure, etc) will require a threshold of when something requires
maintenance

This DBW624S1A: Computer Science  Assignment has been solved by our  Computer Science experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.