4. Question 4 The figure below shows a relational schema of a grocery store. This is from an Access database. Notice sim

[answerhappygod]

4 Question 4 The Figure Below Shows A Relational Schema Of A Grocery Store This Is From An Access Database Notice Sim 1 (496.25 KiB) Viewed 52 times

4. Question 4 The figure below shows a relational schema of a grocery store. This is from an Access database. Notice similarities and differences in the notations: primary key is indicated with a yellow key symbol and foreign key is indicated with the infinity sign instead of FK. Study the structure and create a star (or constellation) schema for a data warehouse which can be used to analyse rental revenues generated by customers and owners. Also, we want to analyse number of days those vehicles are rented by customers. Using the Data Warehouse modelling we have learnt together, draw the star schema of this question. (30p) OWNER Owner ID First Name Last Name Zip Code VEHICLE Owner D Vehicle ID VehideName DailyPrice RENTAL RentallD VehidelD Customer RentDate DaysRented CUSTOMER Customer 10 First Name Last Name State Zip Code