COP 3540 Introduction to Database Structures Spring 2018 Sample Mid Term Exam Na

Question

COP 3540 Introduction to Database Structures Spring 2018 Sample Mid Term Exam Name Grade: 100 3. 30 points) The following relations deacribe a Hollywood movie acbema. Thewovie relation contains information about movies that were released who the lead actor was, etc, the actor relation ccatains infomation about actors such as bith year and the morie budge relation cotaine infomation about movie name, budget, etc. The umique e are mderlined MOVIE ID? NAME LEAD ID CO-STAR ID DIRECTOR FRODUCION CO Teminato Andy Wachowakd Waa Bzo Univenal Picure 4 Heat Michael aWamer Bros ACTOR MOVIE BUDGET REVENLE Tewlestor 1934 1 Kes 964 63 Pacino 260 Linds 956 60 aarancaFiatbuna De Nzo Armola Give the answers of the following relational aebra statements as a table sir, Ot-1250 Actor) Movie)

Explanation / Answer

If you have any doubts, please give me comment...

i)

movie.name

The matrix

Jaws

ii)

FirstName

LastName

Keamu

Reeves

Robert

De Nero

iii)

name

year

Terminator

1934

Jaws

1975

iv)

Lead_id

3

8

v)

Empty set

SELECT COUNT(*)

FROM Movies

WHERE `PRODUCTION CO.` = 'Warner Bros.';

SELECT NAME, YEAR

FROM MOVIE M, MOVIE_BUDGET MB, ACTOR A

WHERE M.NAME = MB.NAME AND M.`CO-STAR_ID` = A.`LEAD_ID` AND A.FirstName='Al' AND A.LastName = 'Pacino';

SELECT LastName, FirstName

FROM ACTOR

WHERE Birth_Dt = (

SELECT MIN(Birth_Dt)

FROM ACTOR

);

movie.name

The matrix

Jaws

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.