need sql/pl sql developer to create scripts

  • Статус Закрито
  • Бюджет ₹100 - ₹400 INR / hour
  • Усього заявок 1

Опис проекту

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]

Отримайте безкоштовно цінові пропозиції на схожі проекти

Хочете заробити?

  • Визначте бюджет та часові рамки
  • Опишіть свою пропозицію
  • Отримайте оплату за свою роботу

Найняти фрілансерів, які також подавали заявки в цей проект

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