Data Discovery, Dimensional database

With the given data a dimensional database needs to be made with queries and SQL programming might be required and also the questions in the document be answered from the database.

Attached is the data needed to make the database and the questions that needs to be answered in the work document.