Question
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
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_noStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started