Question: A. 1 b E LT Heading 1 T Heading 2 T Heading 3 T Heading 4-Thea . - Paragraph Short Answer Revision Exercise Write down
A. 1 b E LT Heading 1 T Heading 2 T Heading 3 T Heading 4-Thea . - Paragraph Short Answer Revision Exercise Write down answers to the following questions: Question 1 (3 marks) Briefly describe the differences between the candidate keys and the primary keys of a table. (1.0 marks) Give xamples to illustrate your answer. (2 marks) Question 2 (3 marks) Explain what is meant by a foreign key. (1 mark) How do foreign keys of tables relate to primary keys? (1 mark) Give examples to illustrate your answer. (1 mark) Question 3 (3 marks) Explain the function of each of at least three of the clauses in the SELECT statement (2.5 marks). What restrictions are imposed on these clauses (0.5 marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
