HW#5 --- last modified March 02 2019 17:05:24..
Solution set.
Due date: Dec 8
Files to be submitted:
Hw5Problems.pdf
Grant.txt
Object.txt
Purpose: To gain familiarity with DBMS
recovery algorithms, tuning, security, and object orientation.
Specification:
Do the following problems our of R & G: 18.5, 20.4, 20.6.
Submit these as Hw5Problems.pdf. In addition,
I want you to submit spools of a GRANT experiment together with
any scripts you use in intially setting up your tables as Grant.txt. Then I also want
you to submit the script file Object.txt that you used to carry out an
OO-experiment.
For the GRANT experiment work with a friend whose name
you provide (along with your own name, of course)
at the top of your submission. To set things up I want you to create a table
Employee(fname, lname, salary, address). I leave the types of the attributes up
to you. Insert some rows into this table and REVOKE FROM your friend
SELECT privileges on this table. Give a spool showing your friend not being able
to see the rows. Next create a view of the columns fname, lname, address of
this Employee table where the first name begins with Bob. GRANT your friend
SELECT privileges on this view and give another spool showing your friend trying
to access this view.
For the OO-experiment, I want you to create a type address(city, state, zip).
Again, I leave the exact details of the attributes up to you.
Then create a table Employee(fname, lname, salary, address) and insert a
couple of rows into this table. Then give an XML DTD for this address type.
Create a new table Employee2(fname, lname, salary, address2) that uses an XMLType
to store the address information. Insert a couple of rows into this table.
Point Breakdown
Book problems (2pts each) |
6pts
|
Grant Experiment |
2pts
|
OO Experiment | 2pts
|
Total | 10pts |
|