For full credit, create scripts as described below that will function when started in SQL*Plus at DMACC. Grading will be based on three parts for each script.

1. Documentation of the script and its function is in the script.

2. Does it run and complete its goal successfully?

3. Is it written simply and with structured programming techniques learned in CIS 332?

Each part above will be worth at least a point each. Your score will be translated to 100 points and will be recorded in the test part of the course.

Create a script, WU_SC.sql, that will create a sequence engine to provide primary keys for the SONG table.

Create a script, WU_CT.sql, that will create a table for a collection of songs. The attributes will be record key(N4), song name (A25), artist or group(A25), type(A1), year released(N4), date entered(D), length in minutes(N4), rating(A1).

“Type” will be used for the genre of the song, example: RAP, R&B, CONTRY, ROCK, etc. Only these are allowed

“Rating” will contain your opinion of the song, example: GREAT, GOOD, OKAY, DUMP, etc. Only these ratings are allowed

You will need to create two more tables for the “type” and the “rating”. The type will need to contain the expanded type of song, and the rating will have to contain your opinion based on a single digit code that you create. Be sure and constrain the SONG from having data that is not in the type or rating table. 6 points

Create a script, WU_IDX.sql, to index the year, song name, and artist.

Create a script, WU_DE.sql, to capture the content of an entity for the song table via the keyboard. Each time the script is started, a song will be added to the SONG table. Be sure and list the required codes for the entry person to pick the correct code for the type and rating. This should show for each record to be keyed into the table. Use today’s date for the date entered. 6 points

Create a report, WU_R.sql, that will list all the songs in the SONG table by year released within the song name. Be sure and provide a total of songs at the end. Also, totals by the types and by the ratings should show at the end of the report. 6 points

Create a query, WU_Q.sql, that will list all the songs in the SONG table by prompting for the attribute name, then prompting for the content of the attribute needed, show the result via the WU_R script above.

Questions will be answered when this sheet was given out, if you have any after receiving this sheet in class, you will need to make assumptions to create these scripts.