Question: Actor actorID firstName lastName a1 Scarlett CREATE TABLE Actor ( CREATE TABLE Movie ( actorID VARCHAR(5) PRIMARY KEY, movieID VARCHAR(5) PRIMARY KEY, firstName VARCHAR, name

Actor actorID firstName lastName a1 Scarlett CREATE TABLE Actor ( CREATE

Actor actorID firstName lastName a1 Scarlett CREATE TABLE Actor ( CREATE TABLE Movie ( actorID VARCHAR(5) PRIMARY KEY, movieID VARCHAR(5) PRIMARY KEY, firstName VARCHAR, name VARCHAR, lastName VARCHAR, releaseDate DATE, gender CHAR) length INTEGER, CREATE TABLE Acts In ( genre VARCHAR, actorID VARCHAR(5), actingBudget INTEGER ) movieID VARCHAR(5), pay INTEGER, PRMARY KEY (actorID, movieID), FOREIGN KEY (actorID) REFERENCES Actor(actorID) ON DELETE SET NULL, FOREIGN KEY (movieID) REFERENCES Movie (movieID) ON DELETE CASCADE / Johansson 'Driver' 'a2 Adam' 'a3 Alan' 'Alda 'a4 'Azhy' 'Robertson 'a5 'Takeshi' "Kitano Actsin Movie actorID movieID pay movielD name release Date length genre actingBudget 'al' ' m1 500 ' m1 'drama' 1800 a1 'm2 400 'm2' 2019-07-01 120 2019-08-01 150 2019-01-01 120 'a1 'm3 450 'Marriage Story Vojo Rabbit Ghost in the Shell 'Star Wars: Episode IX - The Rise of Skywalker' 'comedy 1200 'fantasy 1000 'm3' 'al' 'm5 400 'a2' 'm1 200 'm4 '2019-05-01 150 'fantasy' 1100 'a2' 'm2 100 'm5 'Rough Night' "2017-06-16' 101 'comedy 800 'a2' 'm4 100 'm6 'Bridge of Spies' 2015-10-04 141 'drama' 1400 'a3 'm1 300 'a3' 'm6 300 Consider the above database schema and the sample data. (a) Evaluate the following query on the above data and write your answer as a set of tuples. 'a4' 'm1' 300 'a4' 'm3' 350 'a5' 'ml' 400 (b) Explain (in English) what does the query compute. Note: The data in this question is slightly different than the other questions. a5 'm2 600 R1 = II actorID, movieID (Ogenre='drama' (ActsIn Movie)) R2 = II aID,MID (Ogenre='fantasy' (p actorID-aID,movieIDmID (ActsIn) p movieID=mID (Movie))) II actorID (O MID=NULL (R1 (actorID = ID) R2))

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Write an SQL statement to list ItemID and ItemDescription for all items that cost $1000 or more. Write an SQL statement to list ItemNumber and Description for all items that cost $1000 or more and...

1) Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in the metadata of Assignment 1. You may need to use a combination of DROP TABLE, CREATE TABLE, and...

Problem Statement: You are asked to design a database called MOVIES that keep track of various data on movies, actors, roles in movies and famous quotes in movies. So far the following 5 tables...

Write and execute the SQL commands in VLABS SQL Server to create the seven tables and the primary/foreign keys for those tables. The seven tables are on the right hand of the picture, which are:...

Please answer all the 3 parts of this question. Thank you. Part 1 E-R diagram that shows how these five tables should be related to identifying the correct relationships (one-to-one, one-to-many,...

Assume each of your 5 customers rents 2 movies each. Create 5 different transactions that will record each customer renting 2 different movies. Use commit on all instances. Do use Rollback on one of...

moviedbnew_data.sql # TEST DATA -- /* Data for Person table */ INSERT INTO Person (first_name, last_name, lives_in) VALUES('Victor' , 'Fleming', 'NY'); INSERT INTO Person (first_name, last_name,...

Question: Build a SELECT that lists the unique rental rates across all films. Expected Result Set Size: 3 Rows Here is the schema used: -- Sakila Sample Database Schema -- Version 1.0 -- Copyright...

A chemical plant produces a product through a reaction that takes place in a packed bed reactor. The reaction rate is given by the equation: -dC/dt = k * C^1.5 where C is the concentration of the...

From the following data, calculate the cost of capital for operations (WACC). Use the capital asset pricing model to estimate the cost of equity capital. U.S. Government long-term bond rate ..........

i want to check this one why is wrong the one in red

a = ( ( 7 . 2 2 ) 1 0 1 4 ) 2 2 + ( 1 . 5 7 1 0 7 ) 2 =

How do Data Types perform data validation?

How does Referential Integrity work?

What are Dimensional Relational Databases designed to hold primarily?