IV1351-Data-Storage-Paradigms

Task 3

How to create, insert and test:

Run soundgood_create.sql to create the database.
Run soundgood_insert.sql to insert the mock data.
Run either soundgood_views.sql, or files 1-4 in task 3 queries to create the views.
Run historical_data.sql to insert historical data.
Test views and historical data using test.sql

Task 4

How to run:

Download and install Visual Studio 2022 including ASP.NET package.
Open Soundgood.sln with Visual Studio 2022.
Create then match the database information with ConnectionStrings in appsettings.json.
Run soundgood_create.sql to create the database.
Run soundgood_insert.sql to insert the mock data.
Run the project by clicking the start button in the toolbar in Visual Studio 2022.