Reference no: EM131405255
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.
|
Allocation of work assignments and resources
: 1) The following table shows the allocation of work assignments and resources needed for an investment firm to make a decision on investing in company XYZ. a) Create Responsibility Matrix
|
|
What is the difference between data and information
: What is the difference between data and information?What is granularity? What are the advantages of coarse-grain architecture and fine-grain architecture?
|
|
How large a simple random sample will be necessary
: If a larger study is to be undertaken, how large a simple random sample will be necessary to have 99% con- fidence that the sample mean will not differ from the actual population mean by more than 1.0 points?
|
|
Financial variables that affect the price-earnings ratio
: 1. Discuss some financial variables that affect the price-earnings ratio. 2. Explain how the Du Pont system of analysis breaks down return on assets. Also explain how it breaks down return on stockholders' equity.
|
|
Create your own short and simple jdbc java code
: 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 = v..
|
|
Perception on the company performance
: Managers continually use innovative ways to reach their objectives. The main issue is whether managers can influence earning reporting to achieve investors' perception on the company's performance.
|
|
Explain what is meant by the stocks expected return
: FIN 3331- Explain what is meant by the stock's "Expected Return". Calculate each stock's coefficient of variation. Under what situation is the coefficient of variation useful? Briefly explain.
|
|
Major concerns regarding us energy policy
: (1) Identify at least three major concerns regarding US energy policy. What are our vulnerabilities and challenges?
|
|
Source of competitive advantage
: Do ethical practices affect a firm's ability to develop a brand name as a source of competitive advantage? If so, how does this happen? Identify two (2) brands that are a source of competitive advantage in part because of the firm's ethical practic..
|