Consider the following relational database schema: • Movies (title, year, length, studioName) A tuple (t, y, l, s) indicates that a movie with title t was produced by studio s in year y, and the length (in minutes) of the movie was l. • Stars (starName, title, year) A tuple (s, t, y) indicates that the star (i.e., actor or actress) with name s acted in a movie with title t in year y. Express each of the following queries in relational algebra (not in SQL): (a) Find the title and year of every pair of movies that have at least one star in common. (b) in any single year. Find the name of each star who never acted in more than one movie (c) the "Paramount" studio between 2000 and 2019. Find the name of each star who acted in every movie produced by

Consider the following relational database schema: • Movies (title, year, length, studioName) A tuple (t, y, l, s) indicates that a movie with title t was produced by studio s in year y, and the length (in minutes) of the movie was l. • Stars (starName, title, year) A tuple (s, t, y) indicates that the star (i.e., actor or actress) with name s acted in a movie with title t in year y. Express each of the following queries in relational algebra (not in SQL): (a) Find the title and year of every pair of movies that have at least one star in common. (b) in any single year. Find the name of each star who never acted in more than one movie (c) the "Paramount" studio between 2000 and 2019. Find the name of each star who acted in every movie produced by

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

Similar questions

DATABSE
The entity relationship diagram below models the components of a database belonging to the South African Film Writers' Association. The database allows SAFWA to keep track of movies filmed in South Africa, developed by domestic and international studios. The MS Access database diagram below shows the tables created for a travel agent company called TravelSpace. They implemented their database to keep track of their customer's bookings for the different trips they have available. The company offers multiple tours which can be booked by many different customers. Given the diagram below, answer the following questions by providing SQL statements. CUSTOMER BOOKING CUST NO CUST FNAME BOOKNG NO TOUR BOOKING EMP ID CUST NO BOOK STATUS CODE 7 TOUR ID 7 80OENG NO TOUR DATE TOUR CUST LNAme CUST ADORESS CUST DOB CUST EMAIL OUT SEAT NO IN SEAT NO CUST, PHONE 1 TOURO TOUR NAME TOUR DESCRIPTON EVENTJD HOTEL_D TOUR PRICE ADULT FUGHT NO BOOK, TOTAL, COST BOOKNG DATE TOUR PRICE CHILD TOUR, PRICE CON…
Question A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…
create a Relational Schema by mapping
The following relational database schema stores information about a restaurant. The primarykeys are underlined and field types are omitted. Study the schema and its correspondingdescription to answer the questionsCustomer (cid, cname, cage, caddress, cphone)Table (tno, capacity, availability)Item (iid, iname, price)Order ( oid, cid, iid, tno, quantity)Employee (eid, ename, eaddress, eage, salary)Reservation (rid, eid, cid,date, time)The customer is someone who eats in the restaurant. The Customer relation provides customer id, the name, age, address and phone number information. The Table relation gives the restaurant'soccupancy information that includes the table number, the number of people who can sit on thetable, and the table's availability information. The restaurant serves several items. Each of the Itemshas an identification number (e.g 82285), name (e.g, salad), and unit price (e.g.,$15). Soon afterarrival in the restaurant a customer places an order. Order relation contains…
Giving the following schema for a supermarket database, specify the domain constrains for each attribute. CUSTOMERS (CustomerID , First_Name, Last_Name) EMPLOYEES (EmployeeID, Name, Email, PhoneNo) INVOICES( InvoiceID, Amount_Paid, Invoice_Date)
QUESTION 1 15 points We have been asked to develop a database system for a tourism office. The system needs to keep information about customers, cities around the world and hotels in these cities. Each city has name, country and weather that is made up of average temperature in summer and average temperature in winter. Different cities can have the same name in different countries, but for one country the city names are unique. For each city, the system needs to keep information about the number of hotels in the city. For each hotel, the system must store the hotel name (which is unique for a given city), rating, contact (Email, Telephone, fax) and hotel address. The hotel rating is an integer number between 1 to 5, where 1 indicates a very low rating and 5 indicates a very high rating. For each hotel we need to store the number of rooms for each type, for example: a hotel may have 20 rooms of type single and 15 rooms of type double. The system also store the reservations made by the…