Show the answers to the following SQL commands [Based on the Attached Scenario

Show the answers to the following SQL commands [Based on the Attached Scenario] (10 points).

UPDATE Student SET Status = ‘SM’ WHERE Name = ‘CHARLES’; (by User FRED)

SELECT * FROM Student (by User Red)

5. The following questions are all based on user SMITH [Based on the Attached Scenario] (10 points).

If you wanted to connect to Oracle as user SMITH how would you do it successfully? (show each step it would take to successfully connect to Oracle).

6. Show the answers to the following SQL commands [Based on the Attached Scenario] (10 points).

a. UPDATE faculty SET Rank = ‘Professor’ WHERE Name = ‘LOONEY’; (by User LOONEY)

b. UPDATE faculty SET Address = ’14 West’ WHERE Name = ‘MARTIN’; (by User LOONEY)

7. Jajodia Sandhu Model (30 points).

Employee

SSN C1 Name C2 Salary C3 DN C4 TC
001 U Able S 20000 U C100 U S
002 U Bond U 45000 S C200 U S
003 U Coe C 70000 S C300 C S
004 U Drake C 135000 TS C400 C TS
Suggested way to proceed:

Take the original multilevel table given and decompose it into two tables. One at the Secret level (containing everything that should be shown as the Secret Level) and one at the Top Secret level (which is actually the same as the original table at this point).

Use these two freshly created tables as the input tables for both parts a and b (in other words DO NOT use the OUTPUT result from a as input to b).

For part a. Apply all the transaction to the two new tables and show the end result as your answer to part a (as updated set of both tables).

For part b. Apply all the transaction to another fresh copy of the two new table (meaning don’t use the output tables from part a as input to part b) and show the end result as your answer to part b.

a. Suppose an S-subject requests the following insert operations (show the effect on the instance tables for both the secret and top secret level). Your answer will be two new tables (one at the Secret Level and One at the Top Secret Level — with the necessary changes included –) that show the result of the inset and update transactions below (15 points).

INSERT INTO Employee

VALUES 005, “Jones”, 80000, “C400”;

INSERT INTO Employee

VALUES 001, “Able”, 90000, “C300”;

UPDATE Employee

SET Salary = 50000

WHERE Name = “Bond” or “Drake”;

b Suppose a TS-subject request the following insert/update operations (show the effect on the instance tables for both the secret and top secret level). Your answer will be two new tables — with the necessary change included — that show the result of the inset and update transactions below (15 points). Remember: For part b. Apply all the transaction to another fresh copy of the two new table (meaning don’t use the output tables from part a as input to part b) and show the end result as your answer to part b.

INSERT INTO Employee

VALUES 002, “Bond”, 90000, “C300”;

UPDATE Employee

SET Salary = 60000;

NOTE: There is NO WHERE Clause in this statement. T

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"