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

Individual outsourcing risksprepare a 8- to 10-slide

Individual: Outsourcing Risks Prepare a 8- to 10-slide PowerPoint presentation, including speaker notes, that identifies the possible risks to an organization in each of the following outsourcing situations: • The use of ...

Organizations want information organizations need

Organizations want information. Organizations need information. However, information must be in an organized format that supports the creation of business intelligence. Otherwise, according to Rebecca Wettemann, vice pre ...

Unlimited pickers is a group of workers who have joined

Unlimited Pickers is a group of workers who have joined together to provide harvesting services to farmers who need to have their crops brought in. The organization has many teams of workers who travel from location to l ...

Homeworkgiven the relations below answer the following

HOMEWORK Given the relations below, answer the following queries using SQL. Note that the tables contain sample records only and do not represent all the possible records that could be stored in these tables. MEMB ERS ME ...

Lab manualin this lab you will learn how to use ddl and

Lab Manual In this lab you will learn how to use DDL and Oracle Enterprise server to create user accounts, modify, monitor and delete them. You will take the first look at object permissions in Oracle. The last assignmen ...

Warehouse management system projectproject deliverablesthe

Warehouse management system project Project Deliverables The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, ...

Database in-class assignment normalizationfor the following

Database In-class Assignment Normalization For the following table, list the functional dependencies and create a database from the table that is in BCNF and 4NF. Movie Rating Showtime Theater The SpongeBob Movie PG 4:00 ...

Discussion questionsdatabase programs are used to store and

Discussion Questions Database programs are used to store and to retain data for a variety of applications, and are often used in conjunction with Web content to deliver dynamic Web pages. Please respond to all of the fol ...

Taskoverview of business casealive amp boating aampb is a

Task Overview of business case: Alive & Boating (A&B) is a small start-up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the availa ...

The discussion questionbased on your research and readings

The discussion question Based on your research and readings for the week, respond to the following discussion topics. • Often, systems have only one level of security when it comes to databases. Imagine that someone is t ...

  • 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