Q.  Normalize the following table upto 3NF. Also create tables and forms in Oracle and insert the data. Attach Screenshots.  Note: this question is related from database subject kindly solved it correctly and completly. Dr ID Dr Name P. No. P. Name Date Time Sur. No. Sur. Name 101 Ali 107 Barber 12-10-2018 10:00 am S1 abc 101 Ali 108 Ahmed 03-10-2018 11:00am S2 xyz 105 Daud 109 Ghafoor 05-10-2018 10:30 am S3 abc1 105 Daud 109 Ghafoor 10-10-2018 10:00 am S3 abc1 135 Zahid 110 Asif 15-10-2018 10:00 am S2 xyz

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 database theory if it is not possible. (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.

Write a query to delete job with id of 10 from job table

Define the term referential integrity constraint. Give an example of a referential integrity constraint for the tables you created for question 1.8.