assignmet 1

q.1

Using SQL Server 2019 Express (https://www.microsoft.com/en-us/sql-server/sql-server-downloads) for this assignment. In this assignment, the Music Store Excel spreadsheet will be uploaded into the SQL database. To complete the assignment you will submit a full- screen snapshot of the database with one table open in SQL Management Studio.

q-2.

In this assignment, using SQL Server 2019 Express, you will generate a query to complete the data analysis process. Use the following query to generate the data for the exercise:

Query 1

SELECT * FROM Artist;

Query 2

SELECT Artist FROM Artist;