نرجوا المساعدة في حل الواجب
آخر موعد للتسليم السبت 9-4-2016

Q1. Consider the relation shown in Figure. How would it appear to a user with classification U? Suppose a classification U user tries to update the salary of "Smith" to $50,000; what would be the result of this action? (2 Marks)
EMPLOYEE
Name
Salary
Job Preformane
TC
Smith U
40000 C
Fair S
S
Smith U
40000 C
Excellent
C
Brown C
80000 S
Good C
S
Q2: Consider the following database. (2 Marks)
EMPLOYEE(Name, SSN, Salary, DNO, SupervisorSSN, JobCode)
DEPARTMENT(DNO, TotalSalary, ManagerSSN)
STARTING_PAY(JobCode, StartPay)
Note that Dept_No in EMPLOYEE table is foreign key. Based on Active Database Concepts, answer the following questions:
Write the active rules (triggers) for following two events
1. Limit all salary increases to 50%.
2. All new hires for a given job code get the same starting salary, which is available in the STARTING_PAY table.
Q3. Explain Hybrid fragmentation (1 mark)
************************************************** *************************************