Using the film database you have, answer the following queries in your schema thenwrite them down in this paper.Question two:a) Convert the following for-cursor into: open, fetch, close one:DECLARECursor c1 is select table_name from user_tables;BEGINFOR tables IN c1 LOOPDBMS_OUT.PUT_LINE(tables.table_name);END LOOP;END;b) Create a trigger so that when user tries to update category table, new valuewon't take effect and old data will remain in the database.c) Create a function to return if a particular film has more than 10 actors in it ornot. Film_ActorFilmLanguagePF* actor_idPF* film_idp film idP language_id* nameSMALLINTSMALLINTSMALLINTSMALLINT* titleVARCHAR2 (255)CHAR (20)descriptionVARCHAR2 (255)release_yearF' language_idFSMALLINTSMALLINTSMALLINToriginal_language_id* rental_duration* rental_ratelength* replacement_costratingspecial_features* last_updateSMALLINTNUMBER (4,2)SMALLINTFilm_CategoryNUMBER (5,2)VARCHAR2 (6)PF* film_id*PF' category_idSMALLINTActorSMALLINTP. actor_idSMALLINTVARCHAR2 (255)VARCHAR2 (45)first_name* last_nameF. nationalityTIMESTAMPVARCHAR2 (45)CHAR (2)CategoryP* category_idSMALLINTVARCHAR2 (25)Country* nameP. country_idU* short_codeSMALLINTparent_catSMALLINTCHAR (2)* nameVARCHAR2 (25)

A) DECLARECursor c1 is select table_name from user_tables; BEGINOPEN c1;FETCH c1 INTO tables c1…

Answered: ) Create a trigger so that when user…

Systems Architecture

7th Edition

ISBN:9781305080195

Author:Stephen D. Burd

Publisher:Stephen D. Burd

Chapter3: Data Representation

Section: Chapter Questions

Problem 3RP

See similar textbooks

Related questions

Question

Using the film database you have, answer the following queries in your schema then
write them down in this paper.

Question two:
a) Convert the following for-cursor into: open, fetch, close one:
DECLARE
Cursor c1 is select table_name from user_tables;
BEGIN
FOR tables IN c1 LOOP
DBMS_OUT.PUT_LINE(tables.table_name);
END LOOP;
END;

b) Create a trigger so that when user tries to update category table, new value
won't take effect and old data will remain in the database.

c) Create a function to return if a particular film has more than 10 actors in it or
not.

Film_Actor
Film
Language
PF* actor_id
PF* film_id
p film id
P language_id
* name
SMALLINT
SMALLINT
SMALLINT
SMALLINT
* title
VARCHAR2 (255)
CHAR (20)
description
VARCHAR2 (255)
release_year
F' language_id
F
SMALLINT
SMALLINT
SMALLINT
original_language_id
* rental_duration
* rental_rate
length
* replacement_cost
rating
special_features
* last_update
SMALLINT
NUMBER (4,2)
SMALLINT
Film_Category
NUMBER (5,2)
VARCHAR2 (6)
PF* film_id
*PF' category_id
SMALLINT
Actor
SMALLINT
P. actor_id
SMALLINT
VARCHAR2 (255)
VARCHAR2 (45)
first_name
* last_name
F. nationality
TIMESTAMP
VARCHAR2 (45)
CHAR (2)
Category
P* category_id
SMALLINT
VARCHAR2 (25)
Country
* name
P. country_id
U* short_code
SMALLINT
parent_cat
SMALLINT
CHAR (2)
* name
VARCHAR2 (25)

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions