Film ActorLanguageFilmSMALLINTVARCHARZ (255)VARCHAR2 (2SMALLINTSMALLINTPF actor d SMALLINTPF fim id.im_idlanguaged SMALLINTCHAR (20)SMALLINTnamedescriptionrelease yearanguage_idoriginal_language SMALLINTrenta duration*rentaateengh*replacement_costratingpecial featuresustpdateSMALLINTNUMBER (42)SMALLINTFam CategorySMALLINTSMALLINTNUMBER (52)VARCHARZ 6)VARCHAR2 (255)TIMESTAMPPF Sm idKA categoryActoractor idfirst nameSMALLINTVARCHARZ (45)last rame VARCHAR (4)nationalityCHAR (2)Categorycategory SMALLINTVARCHAR2 (2)Countrycountry d SMALLINTU short_code CHAR (2)VARCHARU (2)namePparent cSMALLINTnameUsing the film database you have, answer the following queries in your schema thenwrite them down in this paper.Question One:Select the total rental_rate for films grouped by their categories. Order the result (afrom largest to smallest.Select all actors who acted together with JOE in any film. Use inner query. (bCreate a view, which has category names and number of films each category has. (cQuestion two:Convert the following for-cursor into: open, fetch, close one: (aDECLARECursor cl is select table_name from user tables;BEGINFOR tables IN cl LOOPDBMS_OUT.PUT_LINE (tables.table_name);END LOOP;END;

Note: As per guidelines provided we are supposed to answer only one question at a time . please…

Fam Acter Fam Language aor SMALLINT SMALLINT anguag SMALLINT CHAR 20) im SMALLINT VARCHARZ (2) VARCHAR2 (2 SMALLINT e name desrton eleae ye dentun SMALLINT INTS vtendeme rental uration entaate ngh placementcost ating pecial features VARCHAR a ustedae SMALLINT NUMBER 42) SALLINT Fm Catgory NUMBER (S) SMALLINT Actor VARCHAR2 category SMALLINT ac fame VARCHARZ (4) laame VARCHAR (4 nationality CR 2) SMALLINT TIMESTAMP Category caegory SMALLINT VARCHAR SMALLINT Country ame county SMALLINT short code CHAR 2) VARCHARU parent Using the film database you have, answer the following queries in your schema then write them down in this paper. Question One: Select the total rental_rate for films grouped by their categories. Order the result (a from largest to smallest. Select all actors who acted together with JOE in any film. Use inner query. (b Create a view, which has category names and number of films each category has. (c Question two: Convert the following for-cursor into: open, fetch, close one: (a DECLARE Cursor cl is select table_name from user tables; BEGIN FOR tables IN cl LOOP DBMS_OUT.PUT_LINE(tables.table_name); END LOOP; END;

Fam Acter Fam Language aor SMALLINT SMALLINT anguag SMALLINT CHAR 20) im SMALLINT VARCHARZ (2) VARCHAR2 (2 SMALLINT e name desrton eleae ye dentun SMALLINT INTS vtendeme rental uration entaate ngh placementcost ating pecial features VARCHAR a ustedae SMALLINT NUMBER 42) SALLINT Fm Catgory NUMBER (S) SMALLINT Actor VARCHAR2 category SMALLINT ac fame VARCHARZ (4) laame VARCHAR (4 nationality CR 2) SMALLINT TIMESTAMP Category caegory SMALLINT VARCHAR SMALLINT Country ame county SMALLINT short code CHAR 2) VARCHARU parent Using the film database you have, answer the following queries in your schema then write them down in this paper. Question One: Select the total rental_rate for films grouped by their categories. Order the result (a from largest to smallest. Select all actors who acted together with JOE in any film. Use inner query. (b Create a view, which has category names and number of films each category has. (c Question two: Convert the following for-cursor into: open, fetch, close one: (a DECLARE Cursor cl is select table_name from user tables; BEGIN FOR tables IN cl LOOP DBMS_OUT.PUT_LINE(tables.table_name); END LOOP; END;

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

Subject Name Theory
Question 5 The description of can be given by a lexical specification, which is usually separate from the syntactic description of the language. The ___________ of a programming language include its numeric literals, operators, and special words, among others. One can think of programs as strings of rather than of characters. (One word, all the blanks would fit the one word, plural)
Formal language
Design PDA ACCPT THE Language
WE LEARN RACKET!!! Racket is a general-purpose, multi-paradigm PL based on the Scheme dialect of Lisp. It is known as a language-oriented programming language and frequently used by various institutions for PL design and implementation. It is also used for scripting, Computer Science education and research purposes. Racket is a great PL used for Programming language theory (PLT) which deals with the design, implementation, analysis, characterization, and classification of programming languages and of their individual features. details, visit: https://racket-lang.org/. For https://en.wikipedia.org/wiki/Racket (programming language) and more First of all, please download Racket: https://download.racket-lang.org/ and install DrRocket or if you prefer, initially try an online editor, e.g.: https://onecompiler.com/racket/. Here is a very simple Intro for you: #lang racket "Hello, World!" Or #lang typed/racket (: fact (Integer -> Integer)) (define (fact n) (if (zero? n) 1 (* n (fact (- n…
software
What language is generated by the following grammar? S SS S SS* Sa
Grammar that produces more than one parse tree for the same sentence is_____ a) Ambiguousb) Unambiguousc) Complementationd) Concatenation Intersection
Hi please assist with a ,bplease explain in detail thanks
Please help 8. The known Grammar as follows: S à AX X à or AX | ️ℇ A à CY Y à and CY | ️ℇ C à not C | (S) | 0 | 1 Question Please define the First Set and Follow Set
O One of the great features of object-oriented programming is the division into objects that represent real- world entities