Q4: Suppose you have the information of some movies are shown in some :Cinema halls, where movie-code have the fallowing details افرض أن لديك معلومات ع أحد دور السينما * Movie category Show type Shown period in days Language of the f mevies D. mavie code movie categroy show type ticket priee RO Shown period in days language of movie umber ef viewer tetal income RD during shown perlod A214A 200 H320E 7 150 D230E 300 A260E 7. 250 1- Find the movie category as fallow A Action, H>Horror ( D>Drama, AAnimation (a p 2 Find the show type as fallow 2 20 ,33D 3 Find the ticket price that depending on the show type as fallow 2D 10000 IRD 3D 12000 IRD LL口

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
icon
Related questions
Question
None
Q4: Suppose you have the information of some movies are shown in some
:Cinema halls, where movie-code have the fallowing details
افرض أن لديك معلومات ع احد دور السينما *
Movie category
Show type
Shown period in days
Language of the f mevies
D.
movie code
movle categroy show type ticket priee RD
Shown period in days language of movie
Pumber of viewer
total income RD
during shown period
A214A
200
H320E
150
7.
D230E
300
A260E
250
1- Find the movie category as fallow
A Action, H-Horror (. D Drama, AAnimation (Sala p)
2 20 ,330D
2 Find the show type as fallow
3- Find the ticket price that depending on the show type as fallow
2D10000 IRD
3D-12000 IRD
4 Find the shown period in days
5- Find the language of movie as fallow A-> Arabic E English
6- Find the total income from Ticket sales.
Transcribed Image Text:Q4: Suppose you have the information of some movies are shown in some :Cinema halls, where movie-code have the fallowing details افرض أن لديك معلومات ع احد دور السينما * Movie category Show type Shown period in days Language of the f mevies D. movie code movle categroy show type ticket priee RD Shown period in days language of movie Pumber of viewer total income RD during shown period A214A 200 H320E 150 7. D230E 300 A260E 250 1- Find the movie category as fallow A Action, H-Horror (. D Drama, AAnimation (Sala p) 2 20 ,330D 2 Find the show type as fallow 3- Find the ticket price that depending on the show type as fallow 2D10000 IRD 3D-12000 IRD 4 Find the shown period in days 5- Find the language of movie as fallow A-> Arabic E English 6- Find the total income from Ticket sales.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Storage Devices
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.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education