Assignment: Database Management Systems
Question One
Explain the idea behind using SEMIJOIN in distributed query processing.
Question Two
In your own words explain what is meant by Data Fragmentation? Given the following customer relation, apply the horizontal fragmentation based on customer's gender.
|
Customer_id
|
Name
|
Area
|
Payment type
|
Sex
|
|
112
|
Ahmed
|
jeddah
|
Credit card
|
male
|
|
211
|
Khaled
|
riyadh
|
cash
|
male
|
|
311
|
Noura
|
madinah
|
cash
|
female
|
Question three
Suppose DBA has created three accounts Alpha, Bravo, and Charlie. Alpha is the owner of the following database schema;
STUDENT: Sid, Lname, Fname, Phone, Gpa
COURSE: Cid, Title, Level, Units, Location, Time
INSTRUCTOR: Iid, Lname, Fname, Designation, Salary, Dept .
Write SQL statements to grant or revoke following privileges. "
Create the views if and when necessary.
a) Alpha wants to allow Bravo to retrieve information from STUDENT and INSTRUCTOR tables and also to be able to propagate the SELECT privilege to other accounts.
b) Alpha wants to give a capability to retrieve Title, Location, and Time from the COURSE relation where the Level = 6 to Charlie and to be able to propagate the privilege.
c) Alpha decides to revoke the SELECT privilege on the STUDENT relation from Bravo
Question Four
Suppose a public sector university in Saudi Arabia wants to implement the strictest access control to its databases. Instead of allowing each user to control access to their own data, the university wants system resources to be controlled by the operating system under system administrator with an hierarchical approach of assigning security labels to the resource objects.
Answer the following questions;
a) Which database security mechanism would you recommend to the university?
b) Motivate your recommendation by describing two advantages.
c) What are the two disadvantages of using this approach?
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.