Question: Include screen shots ( both terminals ) here logged on 1 . What happens after step 2 and why? ( Continue to step 3 and

Include screen shots (both terminals) here logged on
1. What happens after step 2 and why? (Continue to step 3 and 4 and then answer)
2. What happens after step 3 and 4 and why?
Include screen shots(both terminals) here
3. What happens after step 7 and step 8 and why?
4. What happens after step 12 and why?
5. Explain the results (wait to see) of steps 13 to 16 and why?
Include screen shots (both terminals)here
6. What happens after step 17 and why?
7. What happens after step 21 and why?
8. What happens after step 26 and why?
Include screen shots (both terminals)here
Using Music.sql as the script file and the table thats included in the photo Execute the statements below, IN ORDER, observe, take screen shots, and answer the questions (1-8):
\begin{tabular}{|l|l|l|}
\hline Steps & Terminal 1 & Terminal 2\\
\hline 1 & DELETE from recorded_by where songID =213; & \\
\hline 2 & & DELETE from recorded_by where songID =213; \\
\hline 3 & COMMIT; & \\
\hline 4 & & COMMIT; \\
\hline 5 & \begin{tabular}{l}
INSERT Into Artist values('155','Rolling \\
Stones','Brian','Jones','1969','27');
\end{tabular} & \begin{tabular}{l}
INSERT Into Artist \\
values('156','Soundgarden','Chris','Cornell','2017','53');
\end{tabular}\\
\hline 6 & & \\
\hline 7 & SELECT * from Artist; & SELECT * from Artist; \\
\hline 8 & & ROLLBACK; \\
\hline 9 & & SELECT * from Artist; \\
\hline 10 & & SELECT * from Artist; \\
\hline 11 & COMMIT; & \\
\hline 12 & & \begin{tabular}{l}
INSERT Into Song values('275','Black Hole \\
Sun','Rock');
\end{tabular}\\
\hline 13 & & \begin{tabular}{l}
INSERT Into Artist \\
values('160','INXS','Michael','Hutchence','1997','37');
\end{tabular}\\
\hline 14 & & \\
\hline 15 & \begin{tabular}{l}
INSERT Into Artist \\
values('160','ACDC','Bon','Scott','1980','34');
\end{tabular}\\
\hline
\end{tabular}
\begin{tabular}{|l|l|l|}
\hline 16 & & INSERT Into Song values('275','Back in Black','Rock'); \\
\hline 17 & ROLLBACK; & \\
\hline 18 & SELECT * from Song; & \\
\hline 19 & SELECT * from Artist; & \\
\hline 20 & & SELECT * from Song; \\
\hline 21 & & SELECT * from Artist; \\
\hline 22 & & COMMIT; \\
\hline 23 & SELECT * from Song; & \\
\hline 24 & SELECT * from Artist; & \\
\hline 25 & & SELECT * from Song; \\
\hline 26 & & SELECT * from Artist; \\
\hline
\end{tabular}
Include screen shots ( both terminals ) here

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!