(a) Write the insert SQL to populate the Zoom, BB, and the QR tables with the values given below. For each table, use only one insert to complete the insert task. The Duration column is initially empty. (b) Can you insert the ZOOM table first? Provide a reason according to the relational database theory if it is not possible.
4. This question continues from Q3.
(a) Write the insert SQL to populate the Zoom, BB, and the QR tables with the values given below. For each table, use only one insert to complete the insert task. The Duration column is initially empty.
(b) Can you insert the ZOOM table first? Provide a reason according to the relational
(c) Write a Delete SQL to remove student ‘M M’ from the BB table. If it is not possible to remove the row, provide a reason according to the relational database theory. You must not use SID in the SQL because only the name is given.
(d) Write an Update DML that will compute and update the duration in minutesin the Zoom table. Show the updated table and the DML.
Step by step
Solved in 4 steps with 3 images
