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.