Oracle Test database
$30-250 USD
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
Project ID: #6231282
About the project
23 freelancers are bidding on average $173 for this job
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
Dear Sir, I have +5 year experiences in Oracle database development. To Provide Quality, Modular , Result Oriented Work. Thanks & Regards HGDumaswala
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
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
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
Hi , I am a highly experienced Oracle PL/SQL Developer and i would love to work on this project. Thanks a lot
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.
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
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
I have very good experience in DB design and architecture. Also sound knowledge in programming. I have already done many applications of similar requirement.
To surrender: -ERD diagram -DDL script (tables, views, sequences, etc) -Test scripts -which will offer support for 10 days