Develop a car rental transaction schema that captures the pickup of a car at a certain time from a specific location and then return of the car to the same or another location at some later time. Show all the relevant facts in the fact table and the appropriate dimensions along with their attributes. In specifying the attributes, you can make assumptions based on your knowledge of the car rental domain.
Develop a monthly snapshot schema (diagram) based on the car rental transaction schema. The snapshot should cover all the cars that were picked up from a given location during a month. Make sure to include summary facts in the snapshot schema and suppress (add) non-relevant (relevant) dimensions. Show all the keys and attributes of the fact table and the dimensional tables.
Give an example (with the help of a diagram) of a useful three-way or four-way aggregate that you can derive from the car rental transaction schema. Include summary facts in the aggregate fact table, and show all the keys and attributes of the fact and dimension tables.
Specify the grain size for the schema in Q3 (you can use an example to illustrate the grain size).