Question: Use a text editor or Oracle's SQL editor window to write CREATE TABLE SQL statements into a single .txt text/ Make sure you properly handle
Use a text editor or Oracle's SQL editor window to write CREATE TABLE SQL statements into a single .txt text/ Make sure you properly handle the Character table where there is a composite primary key (and individually, the attributes are FK's back to their parent tables). You must pay attention to the order in which you execute your CREATE Tables respecting the Primary/Foreign key relationships. Part 2) Code the INSERT INTO SQL statements to enter data for your 3 favorite movies. You may need to research them a bit to fill out the necessary fields. You need only enter the top 2 leading actors for each of the movies. If an actor acts in more than one of your favorite movies you, of course, would not enter that actor twice. Enter the necessary and associated data into all your database tables. This may require up to 21 rows of data though it could be less than that (e.g. if all your movies are directed by the same director or produced by the same studio). Add these INSERT INTO statements into your script file (created up in part 1). Note that the order in which you insert the data is also important. Be sure to pay attention to the referential integrity rules as you enter the data. For example the Movie record that you insert will need to have a valid StudioID and DirectorID. Part 3) Load and execute the script filecreated in Parts 1 and 2. If it doesn't execute correctly the first time, correct any errors in the script file, delete (DROP) tables (if necessary) and re-run your script until it runs error free. Capture the output from an error-free execution by directing the output to as pool file Part 4) From Developer's SQL window, write and execute the SELECT * FROM table statement, replacing table with the actual table name, to list the data in each of the 5 tables. Capture the output from each of these 5 SELECT statements
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
