Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application Development And Administration

Authors: Michael V. Mannino

3rd Edition

0071107010, 978-0071107013

More Books

Students also viewed these Databases questions

Question

Organizing Your Speech Points

Answered: 1 week ago