Design and develop a relational database

Cerrado Publicado Oct 13, 2014 Pagado a la entrega
Cerrado

Project Requirements:

1. 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. Your design should be normalized and well-designed for scalability for additional customers and shipment locations.

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.

7. You do not need a GUI component but your scripts should demonstrate all of the functionality of the system.

Deliverables:

1. All sql scripts and run scripts and instructions for successfully building your database and testing your database.

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

3. Well-written word document describing:

a. The database design

b. How to set up and test your database

c. The test data and results you used for your database,

d. Your approach, lessons learned, design strengths, limitations and suggestions for future improvement and alternative approaches, the most challenging aspects of developing this application.

Administración de bases de datos Oracle SQL

Nº del proyecto: #6586871

Sobre el proyecto

21 propuestas Proyecto remoto Activo Nov 19, 2014

21 freelancers están ofertando un promedio de $15 / hora por este trabajo

smshafiqulislam

A proposal has not yet been provided

$23 USD / hora
(26 comentarios)
5.1
Reza2012

Hi I have more than 11 years experience in Oracle Database design and administration. Please check my profile. Thanks.

$12 USD / hora
(26 comentarios)
4.9
rohit28lko

Hi... I am an IT Professional and working as a dba since last 5 years... I assure you that your work will be done ASAP as per your requirements. You can see my portfolio in freelancer also. I will provide quality work Más

$13 USD / hora
(3 comentarios)
2.5
nitinbohra89

Having 3+ years of experience in Oracle Database. have vast knowledge of Oracle Architecture,Performance tuning, query optimization. have completed such type of project previously, Please check my profile. Currently Más

$40 USD / hora
(2 comentarios)
1.5
ashishseth1988

Hello, I am working with a MNC based company in a DWH project since last 4 years. This project is pure DWH project which comprised of DWH concept,Informatica as ETL tool and Business Object & Qlikview as report Más

$16 USD / hora
(0 comentarios)
0.0
MRSarker

Hi I am new in freelancer but I have more than 11 years experience in Oracle Database Design and administration. Thanks.

$12 USD / hora
(0 comentarios)
0.0
dbaspecialist

Have total of 20 years of experience, Including 14 years as Oracle DBA. Proficient in ITIL processes and service Delivery. Have managed remotely 1200 Oracle Instances for different customers(45) which had a size ra Más

$33 USD / hora
(0 comentarios)
0.0
ambarishpatel

Good database skill and 7+ year of experience which lead to on time completion of the project and complete the task

$20 USD / hora
(0 comentarios)
0.0
AVSSRachanna

I am ready to design required database design , please message me Más

$8 USD / hora
(0 comentarios)
0.0
tavs

Dear Sir, I have designed large-scaled databases. This was one of my primary tasks for more than 10 years. Of course I offer to do this with the best quality.

$12 USD / hora
(0 comentarios)
0.0
alkasrivastava

I have designed many systems like this in my past job experience of 19 years. I have worked on more complex system. I have bundled up all the deployments of package and objects, which can be easily move from one system Más

$12 USD / hora
(0 comentarios)
0.0
freelancerjee

A proposal has not yet been provided

$15 USD / hora
(0 comentarios)
0.0
darshanmehta9271

I am an Oracle certiied Database SQL expert. During my more than 5 years of development career, I have dealt with almost all kinds of databases. I will be able to do the job quickly and efficiently.

$11 USD / hora
(0 comentarios)
0.0
gak0609

Could you please address the below.. 1. Is this an enhancement or totally new data model that we need to develop 2. Would you be providing any functional(specification) documents. 3. Which OS is your DB running on ( Más

$12 USD / hora
(0 comentarios)
0.0
shashi110189

Was Working With CMM Level -5 , MNC Company. Including Work at Out Of Country Like Oman and KSA . In India Working at Goa , Mumbai , Gujarat . With Different Vertical Company Like Manufacture , Trading ...Etc

$12 USD / hora
(0 comentarios)
0.0
psk270185

Hi I have more than 8 years of experience in designing and developing databases in an Indian Software MNC. Thanks Santosh

$12 USD / hora
(0 comentarios)
0.0
varunmohta1990

I am working as oracle developer and also doing database admin work in current organization.I am well versed in both development and administrator.

$13 USD / hora
(0 comentarios)
0.0
nhpruthi

Hi, I'd like it to be considered for this project. I have experience of almost 3 years in developing project using oracle database as back end. I understand the project requirement, ensure to design relational databas Más

$8 USD / hora
(0 comentarios)
0.0
kyathika

I have been working in Oracle Applications from last 10 year and I will be doing below tasks as a part of this assignment. SOW ----------- 1. Preparation of Documentation with E-R diagrams 2. Tables design with n Más

$12 USD / hora
(0 comentarios)
0.0