https://grouplens.org/datasets/movielens/

1. how to design database schema (draw e-r diagram)

2. put the data into mysql database

3. query examples

4. reporting and visualization analysis

5. others: performance analysis, multiple user access, security access, no-sql analysis

A few more explanations:

a. File type: you can submit a word, ppt or pdf.

b. It's better to have some screenshots of your imported data

c. It is enough to have about 5 query examples. The query should be better as analysis-driven, business requirement driven. The goal is to answer your business requirements, the approach is through sql query.

d. You could use Tableau to visualize the data.

e. You can compare the performance analysis such as "SELECT DISTINCT movie_id" vs "select movie_id group by movie_id". Think about how to design views to offer multiple user access.