Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Homework2 Suppose we have 3 tables which are Users, Videos and Ratings. Each user has a useriD (primary key) and name. Each video has a

image text in transcribed
image text in transcribed
Homework2 Suppose we have 3 tables which are Users, Videos and Ratings. Each user has a useriD (primary key) and name. Each video has a videolD(primary key), uploader (UserID ... Foreign key), length(seconds), and title. Each vedio (UserID + VideolD) is given a rating from 1 to 5 . Table 1: Users Table 2: Videos Table 3 : Ratings 1. For the following math expression length4 (Videos Ratings) How many, and which, are the columns of the answer? (1point) How many tuples are in the results? (2 points) Give, as a table, all of the tuples returned by the query. ( 3 points) 3. write math expression for the following query ( 3 points) Query: selects the uploader of all videos under 20 seconds

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Intelligent Information And Database Systems 12th Asian Conference ACIIDS 2020 Phuket Thailand March 23 26 2020 Proceedings

Authors: Pawel Sitek ,Marcin Pietranik ,Marek Krotkiewicz ,Chutimet Srinilta

1st Edition

9811533792, 978-9811533792

More Books

Students also viewed these Databases questions