Find five random employees from a random department

Select a random working day in your work week. Log all activities that qualify as communication activities (e.g. talking to friends over coffee, obtaining information from a fellow student, providing information, negotiating, advertising, browsing the web). Which fraction of your working day does communication represent?

Delete an employee having ID = 203 (e.g.) Commit changes if that employee’s manager id = 105 Otherwise rollback all the changes. Use Employees table.

Corporation: id 15 17 20 instance: Company: cid id 1 2 3 4 5 15 17 15 20 15 Assumptions: id in Company references id in Corporation. • cid in Department references cid in Company. Department: did cid 1 2 3 4 5 6 7 8 9 10 11 12 5 1 2 2 3 5 1 3 3 1 2 4 Each option starts from the original tables (given above) NOT from the tables modified by the previous option You don't need to copy the entire table. Just explain the action of each operation. (a) Suppose that all the foreign keys are declared using on delete restrict. What is the effect of the instruction delete from Company where cid=2? (b) Suppose that all the foreign keys are declared using on delete cascade. What is the effect of the instruction delete from Corporation where id-15?