Answered: This is data base question. Schema is…

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

This is data base question.

Schema is also uploaded.

1. Show all the movie names with their type names for those movies which has been released during 2000 to 2009. (Use inner join)

2. Show the customer names along with the movie names for which they booked more than 5 seats. (Use inner join)

3. Show the Name of Staff members and their designation who did some booking for the movie ‘Avengers’. (Use inner join)

4. Show the name of movies which were released in both 2D and 3D. (Use Natural join)

5. Show names of all movies along with the staff names who did booking for them. Show all movie names whether they have been booked by any staff or not. (Use Outer Join)

6. Show all category names along with the movie names that lie in the category. Show all categories whether any movie is there of that category or not. (Use Outer Join)

7. 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)

8. Show movie names along with the total number seats that were booked for it. (Use Aggregate Function)

9. Show category names along with the number of movies present in that category. (Use Aggregate Function)

10. Show movie names which has a play time of more than 2 hours or they are in 3D.(Use set operations)

11. Show staff names who live in ‘kharian’ but they have not done any booking as yet. (Use nesting)

12. Show category id which has no movies.

13. Show movies having same release dates.

14. Show movie names which have got the maximum bookings.

15. 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.

a. Strcmp

b. Replace

c. Length

d. Concat

e. Datediff

f. Sysdate

g. Curdate

h. Date

i. Year

j. Month

k. Abs

l. Ceiling

m. Floor

n. 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

Trending now

This is a popular 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