Write a stored procedure that will show all songs

Assignment Help Computer Engineering

Reference no: EM133185464

Case study

You have the following tables: PLAYLIST(Playlistld, SongTitle, SongLength, Artistld) ARTIST(Artistld, ArtistName, ArtistSurname)

a) Write a stored procedure that will show all songs (songtitle, ArtistName and ArtistSurname) in your playlist. Order the list alphabetically by songtitle.

b) Write a C# console application with a method ShowPlaylist that will list all the songs in your playlist in alphabetical order (use your stored procedure from (a)).

You must use a datareader for this. Format your output.

c) Write a stored procedure to calculate the total length of your playlist. Assume that the song length is in seconds.

d) Write a method called PlaylistLength that will output the total length of your playlist. Convert the seconds to hours/minutes/seconds in C#. Use your stored procedure in (c).

e) Write a stored procedure that will allow you to add an artist. All values must be sent through as parameters.

f) Write a C# console application that will allow a user to add an artist. The user must specify the values that must be added. Use your stored procedure from (a) for this.

Reference no: EM133185464

Questions Cloud

Describe machine learning : Machine Learning and Data mining - Imagine the audience is someone that knows nothing about the concept you are choosing

What is your percent variance : This year you had $450 in sales and last year you had $400 in sales. Answer the two questions below: What is your percent variance

Which is better grouping in terms of within-cluster variance : Which is a better grouping in terms of within-cluster variance and If the initial cluster centroids are at (3,4) and (6,4), what are the final clusters

List the health care funding methods used in canada : List the health care funding methods used in Canada. State the health care funding method used in your jurisdiction and describe the payroll implication

Write a stored procedure that will show all songs : Write a stored procedure that will show all songs (songtitle, ArtistName and ArtistSurname) in your playlist. Order the list alphabetically by songtitle

Should you accept or reject this offer : You have received a special offer of 5,000 cases of cookies at a total price of $55,000. Should you accept or reject this offer

How and where you place new datacenter in network diagram : Show how and where you place new datacenter in the network diagram. Provide the new (updated) network diagram with new datacenter on it

Advantages and disadvantages of having credit card : What are some of the advantages and disadvantages of having a checking account? What are some of the advantages and disadvantages of having a credit card?

Treasuries and mortgage-backed securities : Wall Street is really excited about Fed Meeting on Nov 3 It's finally "taper time.: The Fed starts buying fewer Treasuries and mortgage-backed securities.

User Account

All Pages