$**$Please Solve All, Post Scripts, and Screenshots$**$

The assignment is to create a SQL script in Oracle SQL Developer Data Modeler and run it into Oracle APEX. Here are the steps and deliverables.

$1)$ Access Oracle SQL Developer Data Modeler and create a new Design. Perhaps name it "Student Database Example"

$2)$ Add two tables to the design in the Logical Model. Call them "Class" $($which is the transactional table$)$ and "Professors" $($which is the code table$).$ Add a field for the name $($Class Name and Professor Name$)$ to each table as a VARCHAR$1000$ field. Each table should have primary key $($CLASS$\_$ID$,$ PROFESSOR$\_$ID$)$ which is numeric. Add a date field $($DATE$\_$CLASS$\_$START, DATE$\_$PROFESSOR$\_$HIRED$)$ to the tables also. And the "Class" table should have a column for "Professor" also $($which should be a number field$).$ All of this is done in the Table Properties area using the "Columns" dialouge box.

$3)$ Create a PK$/$FK relationship between the two tables using the Professor data point. You do this in the Table Properties area in the Foreign Keys dialouge box.

$4)$ Engineer this forward to the Relational Model using the icon on the top of the screen with the two right arrows $($following the prompt$).$

$5)$ From the Relational Model, use the DDL File Editor $($under the View menu$)$ to generate the CREATE TABLE and ALTER TABLE scripts.

$6)$ Copy those SQL statements $($should be two CREATE TABLE statements and three ALTER TABLE statments $-$ two for the table primary keys and one for the foreign key$)$ to a text file.

$7)$ Save the text file as a SQL file and run the script in Oracle APEX to create the tables in APEX.

The deliverables for this which can be saved to the assignment are:

$1)$ Screenshot of the Logical model in SQL Developer

$2)$ Screenshot of the Relational model in SQL Developer

$3)$ The saved SQL statement as a text file.

$4)$ A screenshot of the SQL statement output creating the two files in Oracle APEX