1. [6 points] Provide Oracle code to create the tables for the DB schema listed below....

 

Transcribed Image Text:

1. [6 points] Provide Oracle code to create the tables for the DB schema listed below. Assume that all attributes are type number. Be sure you include primary and foreign keys as indicated. List at least one general check constraint. 2. [6 points] Show Oracle code to define a view that results from the join of the two tables and its attributes are only the primary keys of both tables. 3.[6 points] Provide Oracle code for a PL/SQL stored function called "f1" that takes as in parameter the primary key of the first table and return the sum of the last attribute of the table. 4.[6 points] Give an example for each of the following using the schema of the DB for this question (a) one insert statement, (b) one delete statement, and ('c) one update statement DB Schema Table name Attributes Primary key First table angustia ell brain cost dcd Foreign key Second Table tortura pet zebra h76 ell 1. [6 points] Provide Oracle code to create the tables for the DB schema listed below. Assume that all attributes are type number. Be sure you include primary and foreign keys as indicated. List at least one general check constraint. 2. [6 points] Show Oracle code to define a view that results from the join of the two tables and its attributes are only the primary keys of both tables. 3.[6 points] Provide Oracle code for a PL/SQL stored function called "f1" that takes as in parameter the primary key of the first table and return the sum of the last attribute of the table. 4.[6 points] Give an example for each of the following using the schema of the DB for this question (a) one insert statement, (b) one delete statement, and ('c) one update statement DB Schema Table name Attributes Primary key First table angustia ell brain cost dcd Foreign key Second Table tortura pet zebra h76 ell