Question: I need the script for this Project 4 Requirement (Branch Table Creation) Using the DreamHome database schema defined in section 4.2.6, pg. 111 and the

I need the script for this

Project 4 Requirement (Branch Table Creation)

Using the "DreamHome" database schema defined in section 4.2.6, pg. 111 and the "Branch" relation shown in Figure 4-3, pg. 112. Use the SQLPlus environment to create the "Branch" table and insert the records shown, in addition to 10 new records. Be sure to include the "Primary Key" constraint in the table definition. Also include a "DROP TABLE" statement as the first statement in the script.

This is all I was given for this in terms of notes and references:

  1. Refer to the "Data Integrity Data Integrity (Data Integrity (oracle.com)" chapter of the "Oracle Database Concepts" for description of the database integrity constraints supported by Oracle.
  2. Refer to the "Data Types" section of the "SQL Language Reference" for descriptions of the Oracle data types, specifically for this activity focus on the "Oracle Built-In Data Types (Links to an external site.)" .
  3. Refer to the SQL Reference manual for the proper syntax for the "CREATE TABLE" and "DROP TABLE" statements.
    1. CREATE TABLE (Links to an external site.)
    2. DROP TABLE (Links to an external site.)
    3. The SQL Plus User's Guide & Reference (Links to an external site.), is another resource that describes the use of scripts.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!