Reference no: EM131309409
Oracle Database
Using the Schema you developed in Homework 1 for your e-Commerce project, design and implement a Virtual Private Database that limits database access. Your design should be based on two of your columns and two of your tables. (Hint: where col1 = value1 AND col2 = value2). Which columns and tables you choose is up to you and will be based on your initial design. You may alter your tables if it makes sense to do so.
In most cases you will need to create a separate policy and function for each of the two tables you select. Use the tutorial as a reference and follow the steps for creating the policy function, creating the virtual private database policy and testing the policy.
Deliverables:
1. Create a word or PDF document that describes your process, steps and results. Be sure to describe your schema and why you selected the tables and columns you did for your Private database. Provide screen shots showing the successful running of all of your SQL statements and testing your implementation. Be sure your testing is comprehensive and clearly demonstrates how the virtual private database restricts access to specific records. The document should be neat, well-organized, well-written and contain minimal grammar and spelling errors.
2. A .sql script file containing all SQL statements you used for this effort. All SQL statements should be in one file with appropriate connect statements to differentiate users who run the script. The script file should contain comments describe each major set of SQL statements. The script should run perfectly without error when executed from the Oracle SQL*PLUS environment.
3. Create your own short and simple JDBC Java code example that inserts 2 records into an Oracle table of your creation.
From a design perspective, the Java functionality should be separated into methods and use prepared Statements for your SQL statements.
Post your fully functional code along with screen shots demonstrating the successful running of it.
Note this code should compile and run from the command prompt.
|
Discuss the interplay of the endowment effect
: If your employees are completely rational, will they be motivated more by Scheme A, Scheme B, or will both schemes motivate them equally?
|
|
Global production to china
: a) What are the benefits to Philips of shifting so much of its global production to China? b) What are the risks associated with a heavy concentration of manufacturing assets in China?
|
|
How does your list compare to the other groups lists
: Make a list of all the suggestions, and then share your list with the other groups.- How does your list compare to the other groups' lists?
|
|
Converters for the aerospace industry
: FCX Systems, which manufactures power converters for the aerospace industry, realized that to continue to grow, the company would have to seek opportunities in foreign markets. Today, the company is the recipient of numerous accolades for its expo..
|
|
Create a word or pdf document that describes your process
: Create a word or PDF document that describes your process, steps and results. Be sure to describe your schema and why you selected the tables and columns you did for your Private database.
|
|
What do you think is important to include in your review
: Prepare to write a review of a restaurant or a dining facility on campus. Use the process outlined:- How will you organize your main and supporting points?
|
|
Largest value of relative optimism
: Assume that litigation will cost the plaintiff $100 and the defendant $100. Assume that settling out of court is free (SC=$0). What is the largest value of relative optimism (DEJ) at which the parties can still settle out of court? Explain.
|
|
Create a flowchart that is also a fully functional program
: Using Visual Logic, design a flowchart that is also a fully functional program to add functionality to the online shopping cart.
|
|
Consequences which are unintended by the government
: In contrast, read this blog post; according to the post, why might anti-gouging laws not increase social welfare, or at least why might they lead to consequences which are unintended by the government?
|