Module $12-$ Concurrency

Assignment Purpose: Identify potential conflicts in transactional processing, Identify potential deadlocks in transactional processing

Using the music.sql script file provided, create the Event schema $($Song$,$ Recorded$\_$by$,$ Artist$)$:

SQL$>$ @music.sql

What to Submit $(3$ DOCUMENTS$)$

ONE document will be submitted that includes answers and screenshots

Assignment file$($ there are a total of $8$ Questions$)$ as a Mod$12$LastnameFirstname.pdf

Include the questions numbered and in order

Include the following $4$ screenshots:

Both terminals when you log on

Both terminals after question $2$

Both terminals after question $5$

Both terminals after question $8$

PART $1$ Directions $-$ Query Optimization

OPEN $2($TWO$)$ separate terminal

Log on to

Oraclelinux.eng.fau.edu on each terminal

Connect to the database $($sqlplus username$/$password$)$

Change the line size to $300$ on each terminal

Execute the statements below, IN ORDER, observe, take screen shots, and answer the questions $(1-8)$:

$\backslash$table$[[$Steps$,$Terminal $1,$Terminal $2],[1,$DELETE from recorded$\_$by where songID $=213$;$,],[2,,$DELETE from recorded$\_$by where songID $=213$;$],[3,$COMMIT;,$],[4,,$COMMIT;$],[5,\backslash$table$[[$INSERT Into Artist values$(\text{'}155\text{'},$'Rolling$],[$Stones$\text{'},$'Brian','Jones',$\text{'}1969\text{'},\text{'}27\text{'})$;$]],],[6,,$INSERT Into Artist values$(\text{'}156\text{'},$'Soundgarden','Chris','Cornell',$\text{'}2017\text{'},\text{'}53\text{'})$;$],[7,$SELECT $*$ from Artist;,$],[8,,$SELECT $*$ from Artist;$],[9,,$ROLLBACK;$],[10,,$SELECT $*$ from Artist;$],[11,$COMMIT;,$],[12,,$SELECT $*$ from Artist;$],[13,$INSERT Into Song values$(\text{'}275\text{'},$'Black Hole Sun','Rock'$)$;$,],[14,,$INSERT Into Artist values$(\text{'}160\text{'},$'INXS','Michael','Hutchence',$\text{'}1997\text{'},\text{'}37\text{'})$;$],[15,$INSERT Into Artist values$(\text{'}160\text{'},$'ACDC','Bon','Scott',$\text{'}1980\text{'},\text{'}34\text{'})$;$,]]$

$\backslash$table$[[16,,$INSERT Into Song values$(\text{'}275\text{'},$'Back in Black','Rock'$)$;$],[17,$ROLLBACK;,$],[18,$SELECT $*$ from Song;,$],[19,$SELECT $*$ from Artist;,$],[20,,$SELECT ${?}^{**}$ from Song;$],[21,,$SELECT ${?}^{**}$ from Artist;$],[22,,$COMMIT ${?}^{\text{'}}$