Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write this query in relational algebra SCREENING {sld, movie, time, screen} Seld, name, address,phone) EMPLOYEE . TICKET tld, eld, sld, timestamp, price, discount Ticket td

image text in transcribedimage text in transcribed

Write this query in relational algebra

SCREENING {sld, movie, time, screen} Seld, name, address,phone) EMPLOYEE . TICKET tld, eld, sld, timestamp, price, discount\ Ticket td eld sld timestamp price discount 11 2018-03-23 3:14p 0 none 2 3 4 2018-03-23 3:16pm 8$ student 332 2018-03-23 3:16pm 4 4 2018-03-23 5:48p 10$ none 5 13 2018-03-23 5:48p 5 lecturer Employee eld name address one 1 Tyler Durden 537 Paper Street(288) 555-0153 2 Diane Selwyn 1612 Havenhurst Dr. (255) 555-7614 3 Tyler Durde 1612 Havenhurst Dr. (255) 555-7614 Screening sld movie ine screen Nosferatu 2 Head On 2018-03-23 7pm Screen 1 2018-03-23 7pm Screen 2 3 Bloody Pit of Horror 2018-03-23 9pm Screen 1 2018-03-23 9pm Screen 2 The Following

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions