In this assignment, you will be working on the relational schema you have obtained as part of Homework Assignment #2. Include your relational schema with your assignment.

Design 9 queries on the relational schema that you obtained in step #. 2 of the queries should be implemented by using the RESTRICT operator. 2 of the queries should be implemented by using the PROJECT operator. 2 of the queries should be implemented by using the one of the INTERSECT, UNION, SET DIFFERENCE, CARTESIAN PRODUCT operators. 2 of the queries should be implemented by using one of the JOIN, E-JOIN, N-JOIN operators. 1 of the queries should be implemented by using the DIVISION operator.

seat name m name _admin_id. password offer id price seat.id no. of seats seats Discount Admin offers works for has end_time st_time admin ic sells ticket no show id tid Theatre has Show tname Tickets all no language location tid show id seat_no price show_date has booking_date C name cid Movie m_id m_name Passwora Customer booking 2 cid release_date actors ticket no email_id Director phone_no