Question

Consider Ace Rent-A-Car, a nationwide automobile rental company. For each car that the company owns, Ace records its unique vehicle identification number (VIN), its “make” (manufacturer), model, year of manufacture, and the manufacturer’s factory in which it was made. Each factory is identified by the combination of its company name (i.e. manufacturer name) and the city in which it is located. We also know its size and the year it was built. Each manufacturer is identified by its unique name, plus its headquarters city and the name of its president. Customers are identified by a unique customer number, plus Ace wants to store each customer’s name, address, and telephone number. Each Ace rental location has a unique rental location number, address, and telephone number. Each Ace rental location is assigned to an Ace region, which has a unique region name, a manager, and the location of the main regional office. Ace wants to develop a data warehouse to store its historical rental data. For each rental, Ace wants to record which customer rented which car from which rental location and when the rental began and when it ended. Ace also wants to record the mileage on the car when the rental began, the mileage when it was returned, whether or not the customer bought the insurance that Ace offered, and the total cost of the rental.

Given this scenario, develop a star schema, which may be a snowflake schema, for Ace’s data warehouse.

Answer 1

Answer:- Ace Rent-A-Car

In this question we have to make a Star Schema for the given data warehouse attributes.

Star Schema is studied in data warehouse. In star schema we keep fact table at the centre of the star which is associated with the various dimension tables.

The structure of Star Schema looks like STAR so we call it star schema. This is the simplest type of Data warehouse schema. Sometimes it is also known as Star Join Schema. Dimension tables are not joined in Star schema.

Fact table contains the key attributes of every dimension table like Car_VIN, Customer_number, Ace_region_unique_name, Factory_ name, Manufacturer_name, Rental_ location_address, Rental _total_Cost and other important attributes.