oracle help

Closed

Description

design a database from scratch using oracle 8. -the database must consist of 4 of more tables with proper relationships in 3NF. - represent the database diagramatically. - create tables using DDL queries. add appropriate data to each table. - create DML queries using substitution variables,views, and nested queries - design data retrieval queries using various joins, functions, set operators and nested queries - utilize various database objects like synonym,view,sequence and index - implement user access control for different objects. - use PL/SQL block(at least one ) for data manipulation. -save each query in individual files with an .sql extension , which can be loaded and used by users -create a simple documentation to support the project -justify creation of each object and its use. -submit the table structures, records , constraint info,queries, and programs.

## Deliverables

Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.

## Platform

Oracle 8

Skills: Database Administration, Engineering, MySQL, PHP, Software Architecture, Software Testing, SQL

See more: working for oracle, used structures, synonym for design, synonym design, sql to oracle, sql oracle pl sql, sql in pl sql, sql code oracle, set data structures, pl sql variables oracle, pl sql source control, pl sql in oracle, pl sql files, pl sql code documentation, pl sql and oracle, pl sql and, oracle sql pl, oracle functions sql, for in pl sql, for all in pl sql, different data structures, design synonym, data structures set, code pl sql, working at oracle

Project ID: #2839519

Awarded to:

anazvw

See private message.

$12 USD in 14 days
(33 Reviews)
4.3

4 freelancers are bidding on average $33 for this job

kasperindia

See private message.

$18.7 USD in 14 days
(35 Reviews)
3.9
kashivw

See private message.

$85 USD in 14 days
(4 Reviews)
3.0
changevw

See private message.

$17 USD in 14 days
(2 Reviews)
0.5