Oracle Test database

Closed Posted Jul 24, 2014 Paid on delivery
Closed Paid on delivery

Using the Oracle database engine, design and develop a relational database to store user information to support a large online shipping company. Information that needs to be stored includes user name, detailed mailing address, and shipping information including number of packages, weight, cost, destination, origin, and tracking information allowing users to determine where a package is, and when and who signed for the package once it arrives. Other business data should be present showing how much the shipment costs and invoicing capability to send bills to customers.

2. Your design should allow for inserting, updating, selecting and deleting information

3. A trigger should be used to generate invoices once a customer reaches $200 in shipping costs.

4. An instead-of trigger should be employed to update and/or populate multi-table views.

5. You should include packages, indexes, views and other helpful database components that will assist you in your design.

6. Your scripts should work perfectly allowing the creation of all of the tables, triggers, views and other database components and provide test scripts that demonstrate the use of the system.

2. An ERD diagram of your database design showing primary keys, foreign keys and other constraints

Database Development Database Programming Oracle Software Architecture

Project ID: #6231282

About the project

23 proposals Remote project Active Aug 30, 2014

23 freelancers are bidding on average $173 for this job

paris2785

Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for E-R diagrams and feedback at https://www.freelancer.gr/u/paris2785.h More

$140 USD in 3 days
(94 Reviews)
6.7
acronymsolutions

Hi, I have gone through your requirements .I am a DBA at CMMI-5 Level company since August 2010.I am working on MySql,SQL Server,Oracle database, I can do your job confidently. I am very much Interested to do your work More

$210 USD in 5 days
(37 Reviews)
5.8
rainbow

A proposal has not yet been provided

$222 USD in 3 days
(24 Reviews)
4.9
elboukharimu

Aucune proposition n'a encore été fournie.

$222 USD in 1 day
(9 Reviews)
4.5
swarm22

Dear Sir, I have +5 year experiences in Oracle database development. To Provide Quality, Modular , Result Oriented Work. Thanks & Regards HGDumaswala

$222 USD in 5 days
(9 Reviews)
3.9
priyamehtag

A proposal has not yet been provided

$45 USD in 3 days
(2 Reviews)
1.1
noorzaman1984

A proposal has not yet been provided

$155 USD in 7 days
(1 Review)
0.8
gnosisengineers

1. creation of database first. 2. creation of schema 3. creation of physical design 4. creation of logical design of above database, 5. creation of tables with attributes as user name, detailed mailing More

$77 USD in 3 days
(0 Reviews)
0.0
AvtarSingh127

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
amifreelancer31

Hi, I have the experience on MS SQL as well as Oracle Database 10G/11G/12c and Oracle SQL Query, Procedure, Function, Trigger, Cursor, Package in Oracle as per your need. I am also expert on Oracle Developer Suite ( More

$250 USD in 7 days
(0 Reviews)
0.0
prawin4u

Experience - Have close to 9 years of experience in Database Management Systems - Have real time experience on Similar project (designed database for a courier company) Approach Day 1: Detailed requirement d More

$221 USD in 5 days
(0 Reviews)
0.0
CodingSmiley

Hi, I am a software professional from India, having a total experience of 7 years working on the technologies like Oracle, PL/SQL, Java script, PHP, HTML,MySQL. I am good in oracle database development using PL/SQL More

$155 USD in 3 days
(0 Reviews)
0.0
mitdave04mdave4

Hi , I am a highly experienced Oracle PL/SQL Developer and i would love to work on this project. Thanks a lot

$133 USD in 2 days
(0 Reviews)
0.0
karun0001

I work on a very large Oracle databases. I would make sure there isn't any performance issues in long run. You can contact me if you have further questions.

$200 USD in 5 days
(0 Reviews)
0.0
PeleOl

Hi! I ready to create a script for a full install for your database. But I have a lot of question about tablespace, account user and other. You have to understand that, otherwise, there will be difficulties in the ex More

$200 USD in 7 days
(0 Reviews)
0.0
jonatasgomes

Hi. I am a 14 years experienced developer with Oracle SQL, PL/SQL and Forms & Reports. Since Oracle versions 8i to 11g, i had created complete systems from models to programs. I am Oracle certified OCA - Oracle C More

$155 USD in 3 days
(0 Reviews)
0.0
charles29020

Hi, I am a Sr. Level Oracle pl/sql developer - dba based in the east coast of the USA. I can generate table creation scripts, user creation scripts and functions and procedures all packaged in a package containing More

$222 USD in 2 days
(1 Review)
1.3
singireddywork

I have very good experience in DB design and architecture. Also sound knowledge in programming. I have already done many applications of similar requirement.

$166 USD in 7 days
(0 Reviews)
0.0
svmagarwal

A proposal has not yet been provided

$155 USD in 5 days
(0 Reviews)
0.0
Nicolas2807

To surrender: -ERD diagram -DDL script (tables, views, sequences, etc) -Test scripts -which will offer support for 10 days

$277 USD in 10 days
(0 Reviews)
0.0