need sql/pl sql developer to create scripts

  • Estado Cerrado
  • Presupuesto ₹100 - ₹400 INR / hour
  • Total de ofertas 1

Descripción del proyecto

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:

[url removed, login to view] -­â€ -­â€ ddl script to create the tables [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view]

[url removed, login to view]

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:\[url removed, login to view]

@ u:\[url removed, login to view]

@ u:\[url removed, login to view]

@ u:\[url removed, login to view]

@ u:\[url removed, login to view]

@ u:\[url removed, login to view]

@ u:\[url removed, login to view]

Obtén cotizaciones gratis para un proyecto como este

¿Buscas ganar algo de dinero?

  • Fija tu plazo y presupuesto
  • Describe tu propuesta
  • Recibes pagos por tu trabajo

Contrata Freelancers que también oferten en este proyecto

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online