Question
you will create the MOVIE database in the Oracle Database using the Oracle Developer user interface. In this assignment, you will build an executable script
you will create the MOVIE database in the Oracle Database using the Oracle Developer user interface. In this assignment, you will build an executable script file that includes all the CREATE TABLE and INSERT INTO statements needed to create and populate the tables with data. Part 1) Use a text editor or Oracle's SQL editor window to write CREATE TABLE SQL statements into a single .txt text/script file. **NOTE: Oracle does not recognize the "COUNTER" data type do your key fields should be typed as Integers in your tables. 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 file created 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. 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started