Reference no: EM131299568
Assignment
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.
Your design should allow for inserting, updating, selecting and deleting information
A trigger should be used to generate invoices once a customer reaches $200 in shipping costs.
An instead-of trigger should be employed to update and/or populate multi-table views.
You should include packages, indexes, views and other helpful database components that will assist you in your design.
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.
You do not need a GUI component but your scripts should demonstrate all of the functionality of the system.
Deliverables:
All sql scripts and run scripts and instructions for successfully building your database and testing your database.
An ERD diagram of your database design showing primary keys, foreign keys and other constraints.
3. Well-written word document describing:
The database design
How to set up and test your database
The test data and results you used for your database,
Your approach, lessons learned, design strengths, limitations and suggestions for future improvement and alternative approaches, the most challenging aspects of developing this application.
|
Define cognitive aid and their application in systems design
: Define cognitive aids and their applications in systems design. Enumerate and explain briefly any four principles affecting flexibility principle. Differentiate between Multi-modal system and multimedia system.
|
|
Efficiency of tax system and equity of tax system
: Analyze the difference between the efficiency of a tax system and the equity of a tax system as it refers to the costs imposed on taxpayers using the benefits principles.
|
|
Do you think virgin’s brand is overextended
: Pick a brand extension. Use the models presented in the chapter to evaluate its ability to achieve its own equity as well as contribute to the equity of a parent brand. If you were the manager of that brand, what would you do differently?
|
|
Can you suggest any changes to its marketing program
: Pick a product category. Examine the histories of the leading brands in that category over the last decade. How would you characterize their efforts to reinforce or revitalize brand equity?
|
|
How to set up and test your database
: How to set up and test your database? An ERD diagram of your database design showing primary keys, foreign keys and other constraints.
|
|
Advance comparative statistics
: Go to the Census Bureau Web site at www.census.gov and select Economic Census, then 2007 Economic Census, Core Business Statistics and then Advance Comparative Statistics.
|
|
Current market conditions competitive analysis
: You have been given the responsibility of working with your organization's CEO to do a competitive market analysis of the potential success of one of their existing products.
|
|
Design a superclass called shape that contains one function
: Area of Shapes: Design a superclass called Shape that contains one function-getArea(). The getArea() function in the Shape class will simply return 0, you will derive from it in your subclasses mentioned below.
|
|
Design your own simple class to represent any household item
: Design and implement your own simple class to represent any household item of your choice (toaster, fan, hair dryer, piano ...) Your class should have a constructor, one additional method and at least one member variable.
|