Data mining

Note: The database must be related to a DVD rental company. So please take this into consideration. Futhermore, for part c) the two operations that need to be running using queries are to find "THE MOST POPULAR DVD SOLD" & "CUSTOMERS WHO HAVE LATE FEE CHARGES TO PAY" b) [ROLAP] Draw a star schema diagram including attributes for your data warehouse. Don't forget to underline primary key attributes and include arrowheads indicating the multiplicity of relationships. Write an SQL database schema for your PDA, using the CREATE TABLE commands (Pick suitable datatypes for each attribute). Using INSERT commands to insert tuples. You need to populate the data warehouse with sample data (at least five attributes for each dimensional table and at least three records each table) for manipulating the data warehouse. For this task, you ONLY need to submit the star schema diagram, and the populated tables. c) [ROLAP] Starting with the base cuboid [e.g., student, module, semester, lecturer], carry out two OLAP operations. For example, what specific OLAP operations should you perform in order to list the average grade of the Data Mining module for each university student in the university scenario? Write and run an SQL query to obtain your list resembling the above example. Provide a screenshot as a proof your query worked.