Question 2 [ULOS 1, 2] 6 Marks a. Explain the differences between the candidate keys and the primary key of a relation.

[answerhappygod]

Question 2 Ulos 1 2 6 Marks A Explain The Differences Between The Candidate Keys And The Primary Key Of A Relation 1 (23.23 KiB) Viewed 8 times

Question 2 [ULOS 1, 2] 6 Marks a. Explain the differences between the candidate keys and the primary key of a relation. [ULOS 1,2] 2 Marks b. Write SQL statements for the following: (ULOS 1, 2] 4 Marks i. ii. iii. iv. To display alphabetical listing of all employees by last name from a table named "Employee" To display the fields staffNo, fName, IName, position, salary, branchNo from a table named "Staff" Display a calculated field "salary" as monthly salary from fields staffNo, fName, IName, salary from "Staff" table Insert one more record into "Staff" table with fields values as "SN07", "Peter", "Clark', 'Manager", 80000,"B12"