Page 1 of 1
Question 2 [ULOS 1, 2] 6 Marks a. Explain the differences between the candidate keys and the primary key of a relation.
Posted: Tue Jul 05, 2022 10:26 am
by 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 10 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"