Write the sql statements for creating the tables for the employee projects database. save these statements in a script called m09_lastnamefirstname_createtables (where lastname is your last name and firstname is your first name). run/execute these commands in oracle application express. upload a copy of your script to ivylearn.
id fields use number(x) datatype
date fields use date datatype
any field that will be a string use the varchar2(x) datatype, where x is the appropriate size of the field
to assist with choosing sizes for the datatypes, some examples of the data for each table created can be found on the last page of this assignment.
write the sql statements for altering the tables in the employee projects database to define the primary key and foreign key constraints. save these statements in a script called m09_lastnamefirstname_constraints (where lastname is your last name and firstname is your first name). run/execute these commands in oracle application express. upload a copy of your script to ivylearn. if the primary key and foreign key constraints have been created in the previous script, ignore this step.