Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

In this project, you would design a secure database with various tables using good relational database design techniques.   

Project Requirements:

1. Using Oracle database engine, design and develop a relational database to store user information to support the large online shipping company. Information which requires to be stored includes user name, detailed mailing address, and shipping information including number of packages, weight, cost, destination, origin, and tracking information permitting users to find out where the package is, and when and who signed for package once it arrives. Other business data must be present showing how much shipment costs and invoicing capability to send bills to customers. Your design must be normalized and well-designed for scalability for extra customers and shipment locations.

2. Your design must permit for inserting, updating, selecting and deleting information

3. Trigger must be used to generate invoices once the customer reaches $200 in shipping costs.

4. Instead-of trigger must be employed to update and/or populate multi-table views.

5. You must include packages, indexes, views and other helpful database components which would assist you in your design.

6. Your scripts must work perfectly allowing creation of all of tables, triggers, views and other database components and give test scripts which shows the use of system.

7. You don't require a GUI component but your scripts must show all of the functionality of 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.

Format:

Documentation format and length:

Word documentation describing and reflecting on your design and approach must be written using Microsoft Word and be no more than 5 pages in length and no less than 2 pages. Font size must be 12 point. The page margins must be 1 inch. The paragraphs must be with double line spacing. All figures, tables, equations and referenced must be properly labeled and formatted using APA style.

Code format:

Header comment block,

Appropriate comments within the code,

Appropriate variable and function names, and

Correct indentation.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91966

Have any Question? 


Related Questions in DBMS

Assignment database environment proposalas one of the

Assignment: Database Environment Proposal As one of the program outcomes for the Bachelor of Science in Information Technology program, students must design and develop a database using professional principles and standa ...

Assignment database modeling and normalizationimagine that

Assignment: Database Modeling and Normalization Imagine that you work for a consulting firm that offers information technology and database services. Part of its core services is to optimize and offer streamline solution ...

Describe a database that might be used in nursing using

Describe a database that might be used in nursing. Using this data, explain the relationship between a field, a record, a table and a database. In addition, what are the advantages of managing database information in Acc ...

Create a small bank account database with one account table

Create a small Bank Account database with one Account table. The Account table Should have fields for account number, customer last and first names, and current balance. The type of database will be Access .Populate the ...

Assignmentthis assignment consists of two sections a design

Assignment This assignment consists of two sections: a design document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file nam ...

Database systems assignment - student enrolment database a

Database Systems Assignment - Student Enrolment Database A. Task Description 1. Overview Your task is to create and test a database in MySQL using PhpMyAdmin. You are provided with a scenario and supporting documents, de ...

Assignmentcreate a simple excel spreadsheet with data to

Assignment Create a simple excel spreadsheet with data to update the database. 1. Create a form (frmUpdateMediaLink) to link the spreadsheet to a table in the database (you can link the spreadsheet manually using the wiz ...

Ms access database assignment helpdo the easy way i really

MS ACCESS Database assignment help (DO THE EASY WAY I really just need this asap) (I have the database file ready to email to you. I dont think it let me upload the database file here.) Create a simple excel spreadsheet ...

Assignmentas the new manager of a convenience store you

Assignment As the new manager of a convenience store, you have noticed issues with the manual method of tracking sales using paper sales tickets and spreadsheets, as well as, shortages on some of the more popular items c ...

Make the menageriegis database using petgissqllook at the

Make the menagerieGIS database using petGIS.sql Look at the petGIS.png to see where the pets are. 1. Display the name, astext location, X and Y values of each pet 2. Display the pets with their location displayed in stan ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen