The first for of the assignment involves the uploading of a dataextract from the production database. You will be provided with a number of files. These will include the DDL for the tables and the initial data extract for each of the tables. The initial data extract will consist of scripts that you can run. These will insert the data into the tables (you do not need to write code of this part).
In your Oracle schema you should run these scripts to create the tables and populate them with the initial data extract.
Full ER diagram to represent the tables extracted from the production schema
! Details of all primary and foreign keys that you can identify
! A data dictionary
Files include:
[login to view URL] -†-†ddl script to create the tables [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL]
[login to view URL]
These files can be found on the module webpage and should be saved to your U:\ drive
In SQL Developer run the following commands to run these SQL scripts @u:\[login to view URL]
@ u:\[login to view URL]
@ u:\[login to view URL]
@ u:\[login to view URL]
@ u:\[login to view URL]
@ u:\[login to view URL]
@ u:\[login to view URL]