Закритий

need sql/pl sql developer to create scripts

Цей проект отримав 1 заявок від талановитих фрілансерів з середньою заявкою у ₹111 INR / hour.

Отримайте безкоштовно цінові пропозиції на схожі проекти
Роботодавець працює
Бюджет проекту
₹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