Closed

Design and develop a relational database - repost

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.

Skills: Database Administration, SQL

See more: test data creation, suggestions of name for online business, sql design online, sql database business, package sql oracle, oracle sql package, oracle database company, oracle company name, online oracle database, online document assist, online administration work, invoices design, how to successfully in business online, how to package design, how much it cost to develop application, how do you design a package, gui application design, functionality diagram, diagram design online, design constraints, business design packages, administration system in a business, oracle sql number, online relational database, 2-d design

About the Employer:
( 0 reviews ) Abu Dhabi, United Arab Emirates

Project ID: #4939478

17 freelancers are bidding on average $13/hour for this job

qualifiedcoders

Hi We have read your [url removed, login to view] are Database experts and have developed some big and complex applications using various databases and have strong expertise in procedures,functions,triggers and other db objects. More

$20 USD / hour
(1 Review)
4.5
elboukharimu

I can help you please check your Inbox

$15 USD / hour
(10 Reviews)
4.2
Reza2012

Hi I have more than 10 years experience in Database design and Administration. Please see PM. Thanks.

$12 USD / hour
(5 Reviews)
3.8
kchg

Hello, sir I'm interested with your project. I'll do it for you. Regards.

$20 USD / hour
(4 Reviews)
3.3
mageny

I work with SQL and PL/SQL since 1992, including ETL and Data Warehouse and I have Oracle Certified Professional (Internet Application Developer Rel. 6/6i). I was instructor of Oracle Academy in Brasil, including those More

$11 USD / hour
(1 Review)
1.6
suraj99p

I am DB expert. I am expert in Oracle database and have very extensive knowledge in this area. I am DB expert of my team and have design ER model for my product and this project matches to my skills. I have very good u More

$12 USD / hour
(1 Review)
0.8
ppn123

Hi, Ready to work. Regards

$12 USD / hour
(0 Reviews)
0.0
rvasdev

I am an Oracle technical architect and a database architect worth 18+ years of industry experience. I have also augmented as a SQL Server Database Architect in past. My capabilities lie in decisive analytical skills, d More

$14 USD / hour
(0 Reviews)
0.0
somorjai

I have more than 18 years experience with Oracle technologies, an Oracle Certified Professional exam and reference at the largest Hungarian spedition company (MASPED). I would like to offer you a solution with package More

$13 USD / hour
(0 Reviews)
0.0
rahulagnihotri25

Dear Kindly review my profile. I am SQL and Oracle Expert with over 10 years of experience in different areas of the two (DB admin and development). I have consulted over 300 clients as an ex-mckinsey consultan More

$12 USD / hour
(1 Review)
0.0
maheshprasad1078

Hi, I am oracle developer at HCL Technologies,,I have vast experience on SQL and PL/SQL. I am new to freelancer,So u can expect better work. Thanks, Mahesh

$8 USD / hour
(0 Reviews)
0.0
cosmo3

Very experienced with designing and implementing oracle databases.

$15 USD / hour
(0 Reviews)
0.0
udroiucristian

I'm have DBA Oracle Certification , and i'm currently working much with MSSQL at my job . I'm a student also at Computer Since so i can work fast,good and eficient. I can be contacted at udroiu_cristian on yahoo dot co More

$8 USD / hour
(0 Reviews)
0.0
nirmeshvats

I am a experience Oracle And Mysql developer. i have around 4 year exprience on Oracle application and mobile application database design and developments and write many process for data fatching. i am looking for a pr More

$13 USD / hour
(0 Reviews)
0.0
mahakarp

A technocrat with 8+ Years (SQL Server2005/2008R2 +SSRS+SSIS) of extensive experience in Software Development Life Cycle (SDLC) & Project Coordination. Presently associated with ISTS InfoTech Solutions Pvt. Ltd. As T More

$12 USD / hour
(0 Reviews)
0.0
DongZhi

Hi , I have been working to design / maintian & consult for ERP systems for multinational trading & manufacturing businesses for years and am very familiar with their business processes & requirements, where shipping / More

$14 USD / hour
(0 Reviews)
0.0
tzelve

I am professional database designer/developer at least 10 year. I have worked in projects that manage physical warehouses and transportation (supply chain management).

$13 USD / hour
(0 Reviews)
0.0