Create all the tables as shown in schema. Import or execute the SQL statements given in data.sql.Write SQL queries for the following statements. Submit screen shot of query and result. Show the name of movies which were released in both 2D and 3D. (Use Natural join)Show all customer names along with movie names they booked. Show all the customer names whether they booked any move or not. Also show all movie names whether they were booked by a customer or not. (Use Outer Join)Show movie names along with the total number seats that were booked for it. (Use Aggregate Function)Show category names along with the number of movies present in that category. (Use Aggregate Function)Show movie names which has a play time of more than 2 hours or they are in 3D.(Use set operations)Show staff names who live in ‘kharian’ but they have not done any booking as yet. (Use nesting)Show movies having same release dates.Show movie names which have got the maximum bookings.From the given database state, write sql queries of your own choice to observe behavior of following functions. Write separate query for each of the following.StrcmpReplaceLengthConcatDatediffSysdateCurdateDateYearMonthAbsCeilingFloorRound categoryscreenCatD INT(11)CatName VARCHAR(25)SreeniD INT(11)OSreenName VARCHAR(25)screen_type vSreniD INT(11)IndexesP TypelD INT(1)IndexesIndexesmovie_categoryO MovielD INT(11)O CatID INT(11)movieMovielD INT(11)O MName VARCHAR(S0)O Realease Date DATE|O Play_tim e INT(1)IndexesIndoxesscreen_moviestypeScreen_Movie_ID INT(11)te o sceening_Date DATEO Shift VAROHAR(25)O MovielD INT(11)OScreeniD INT(11)TypelD INT(11)O TName VARCHAR(2)Indexesmtypemovie_typeTypelD INT(11)O THame VAROHAR(2IndexesTypelD INT(11)MovielD INT(11)bookingIndexesstaftIndexes| customeraD INT(11)o olame VAROHAR(25)O Caddress VARCHAR (50)BID INT (11)O No_of Seats INT( 1)|o saft Booking_Date DATEo Screen Movie D INT(11)o SID INT(1)SID INT(11)SName VAROHAR (25)O sDesignation VARCHAR(25)O Saddress VARCHAR(25)IndexesoaD INT(11)IndexesIndexes

STRCMP(string1, string2) REPLACE(string, from_string, new_string) LENGTH(string) CONCAT(expression1,…

Answered: Write separate query for each of the…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Create all the tables as shown in schema.

Import or execute the SQL statements given in data.sql.

Write SQL queries for the following statements. Submit screen shot of query and result.

Show the name of movies which were released in both 2D and 3D. (Use Natural join)
Show all customer names along with movie names they booked. Show all the customer names whether they booked any move or not. Also show all movie names whether they were booked by a customer or not. (Use Outer Join)
Show movie names along with the total number seats that were booked for it. (Use Aggregate Function)
Show category names along with the number of movies present in that category. (Use Aggregate Function)
Show movie names which has a play time of more than 2 hours or they are in 3D.(Use set operations)
Show staff names who live in ‘kharian’ but they have not done any booking as yet. (Use nesting)
Show movies having same release dates.
Show movie names which have got the maximum bookings.
From the given database state, write sql queries of your own choice to observe behavior of following functions. Write separate query for each of the following.
1. Strcmp
2. Replace
3. Length
4. Concat
5. Datediff
6. Sysdate
7. Curdate
8. Date
9. Year
10. Month
11. Abs
12. Ceiling
13. Floor
14. Round

category
screen
CatD INT(11)
CatName VARCHAR(25)
SreeniD INT(11)
OSreenName VARCHAR(25)
screen_type v
SreniD INT(11)
Indexes
P TypelD INT(1)
Indexes
Indexes
movie_category
O MovielD INT(11)
O CatID INT(11)
movie
MovielD INT(11)
O MName VARCHAR(S0)
O Realease Date DATE
|O Play_tim e INT(1)
Indexes
Indoxes
screen_movie
stype
Screen_Movie_ID INT(11)
te o sceening_Date DATE
O Shift VAROHAR(25)
O MovielD INT(11)
OScreeniD INT(11)
TypelD INT(11)
O TName VARCHAR(2)
Indexes
mtype
movie_type
TypelD INT(11)
O THame VAROHAR(2
Indexes
TypelD INT(11)
MovielD INT(11)
booking
Indexes
staft
Indexes
| customer
aD INT(11)
o olame VAROHAR(25)
O Caddress VARCHAR (50)
BID INT (11)
O No_of Seats INT( 1)
|o saft Booking_Date DATE
o Screen Movie D INT(11)
o SID INT(1)
SID INT(11)
SName VAROHAR (25)
O sDesignation VARCHAR(25)
O Saddress VARCHAR(25)
Indexes
oaD INT(11)
Indexes
Indexes

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions