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

Answer (i) and (ii) only
The following relational schema forms part of an Employees database. The primary keys are underlined and foreign keys are in italics. Job (jobID, jobTitle, minSalary, maxSalary) Dependent (dependentID, firstName, lastName, relationship, employeeID) Department (departmentID, departmentName, locationID) Location (locationID, street, postcode, city, state) Employee (employeeID, firstName, lastName, phoneNumber, salary, jobID, departmentID) Employee employeeID works as jobID at a department departmentID located at locationID. The employee has dependent(s) dependentID. Question 1 Begins Here 1. List employee names, department names, and their dependent names. Also, include employees without any dependents.
Database Systems: Design and Application
Design the database, following an ER model. 1. Patients: Patients are tracked by a unique patient ID. Personal information includes first name, last name, phone number, Date of Birth, and sex. The combination of the Patient's first and last name must be unique. Patient's sex is a mandatory field. Patient can be registered at any clinic. 2. Cancer: Type of cancer is tracked by a unique ID. Cancer is categorized as either Oral, Lung, Breast, Liver, Blood, Bone, Pancreatic, Cervical, or Prostrate. Stage of cancer can be Stage I, Stage II, or Stage III Stage of cancer detection. Treatment given: Chemotherapy only, Surgery with chemotherapy, Surgery only or Radiation therapy. Patient_id is an FK which references the ID of the Patient. Clinic_id is an FK which references the ID of the Clinic that patient register. Patient information must be stored at one clinic. Patient Date of detection of Cancer. 3. Clinic: Clinics are…
QUESTION 7 Consider the following database schema for University Library database. A student can borrow many books and a given book can be borrowed by any student if it is available in the library. For each borrowing, the borrowing and return dates are registered in the database. Student (SID: long, CPR:long (unique), Name:string, tel:number, major:String, gender:Character {"F' or M'}) Book (ISBN:long, Title:string (unique), Author:string) Borrowedltems(stSID:long, booklSBN:long, serialNo.int (unique), BorrowingDate:date, RetumDate:date) Write SQL statements to: 1. List ISBN, Title, Author of all books that include the word 'Database' in their titles in a descending order of ISBN. 2. List SID, Name, and Major of all female students doing major in 'CS' and their name starts with 'S'.
A database table is in 3rd normal form if A It is in 2nd normal form (2NF) and in 1" normal form(INF) B It is in 2NF and all non-key fields depend on all key fields C t is in 2NF and all non-key fields depend only on the key D It is in 2NF and all non-key fields may depend indirectly on all key fields.
A DreamHome database has following tables. Branch (branchNo, street, city, postcode) Staff (staffNo, fName, lName, position, sex, DOB, salary, branchNo) PropertyForRent (propertyNo, street, city, postcode, type, rooms, rent, ownerNo, staffNo, branchNo) PrivateOwner (ownerNo, fName, lName, address, telNo) Which is the correct relational algebra to express the following query? List the city and street of all branches which assistant staff’s salary is not greater than 9000 and age is at least 31. ( ) $$\Pi_{branchNo,street,city}(\sigma_{position='assistant' \wedge salary≤9000 \wedge DOB>'1-Jan-1990'} (Staff \bowtie Branch))$$ ( ) $$\sigma_{branchNo,street,city}(\Pi_{position=’assistant’ \wedge salary≤9000 \wedge DOB>’1-Jan-1990’}(Staff \cap Branch))$$ ( ) $$\sigma_{branchNo,street,city}(\sigma_{position=’assistant’ \wedge salary<9000 \wedge DOB>31}(Staff \bowtie Branch))$$ ( ) $$\Pi_{branchNo,street,city}(\sigma_{position=’assistant’ \wedge salary≤9000 \wedge…
The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined) CUSTOMER (CustID, FirstName, LastName, City, Phone, Email) INVOICE (InvoiceNumber, CustID, Date) INVOICE_ITEM(InvoiceNumber, ItemNumber, Quantity) ITEM (ItemNumber, ItemName, UnitPrice) When a customer makes a purchase, an invoice is created. The invoice may be for many items. For example, in a single purchase, a customer might buy 10 Back Scratchers, 4 Hair Removers and a Dog Lead. Provide relational algebra (NOT SQL) queries to find the following information. NOTE: You can use the symbols s, P, etc., or the words’ PROJECT’, ‘RESTRICT’ etc. as you prefer. You do not need to try to make efficient queries – just correct ones. Where you use a join, always show the join condition. List the dates on which Homer Griffin made purchases. List the first and last names of customers who have bought “Back Scratcher” or “Hair Remover” List the first…
QUESTION 14 Consider the database schema below for cities in countries. A country have many cities, and the same city name can be found in different countries. Country (ID: integer, Name: String (unique), SN: serialNumber (int)(unique)) City (serialNo: integer (unique, not null), CountryID: Integer, CityName: String, Population: integer) The same country (ID , name) can be added twice in Country relation with different SN? No, violates entity Integrity constraint No, violates referential integrity constraint. No, violates key constraint. Yes. No, violates domain constraints.
The conditions under which the database designer should employ supertype and subtype connections are outlined.
Practical Tasks for Database Systems Question:1 Show all data from employee table where name should be in ascending and salary in descending order. Question:2 Show the total length of (eno, deptno). joined it and rename by function from the employee table? Question:3 Show the ename first 3 alphabets of manager? Question:4 Write a query that show the manager data like this. ename job ***MANAGER *** MANAGER JONES BLAKE Question:5 Calculate the percentage of any student and round to 0 digit? Question:6 Show the last date of December 2014? Question:7 Show the date of next data base class and rename by cs-400? Question:8 Convert today date to character?
Given the database schema with the following relations: STUDENT (id_stud, name_stud) LECTURER (id_lect, name_lect) SUBJECT (id_subject, id_lect, name_subject, credits, id_room) ROOM (id_room, no_room) ENROLL (id_stud, id_subject) Create an algebraic relation for: a. Displays all names of lecturers who teach the subject with a total of 4 credits b. Displays all no_room with the student name "Eko" c. Displays all data in the form of student id, student name, name of the course followed and the name of the lecturer who taught the subject name "Database" From the database schema and the questions above, create an appropriate SQL query for each of these statements above.