NSC Information Technology Characteristics of a good database: 4.1.1 In the tblEmployees table

Question

4.1.1 In the tblEmployees table the ID field is intended to save the identity number of the employee, for example 021205510708.

Give ONE reason why it would be incorrect for this field to be an integer data type.

4.1.2 The JobCardNumber field is selected as the primary key in the tblJobCards table.

Explain why none of the other fields in this table would be a suitable primary key.

4.1.3 The NumDaysTaken field indicates how many days it took to complete the job. It has been suggested that the NumDaysTaken field in the tblJobCards table should be included because it is necessary.

Motivate this suggestion.

4.1.4 The manager wants to view a list of jobs that have been assigned to a specific employee. A relationship must be created between the two tables to be able to generate the list.

A field must be added to one of the tables for a relationship to be created.

Indicate the name of:
(a) The field that must be added.
(b) The table this field must be added to.

4.1.1 In the tblEmployees table the ID field is intended to save the identity number of the employee, for example 021205510708 - NSC Information Technology - Question 4 - 2017 - Paper 2

Worked Solution & Example Answer:4.1.1 In the tblEmployees table the ID field is intended to save the identity number of the employee, for example 021205510708 - NSC Information Technology - Question 4 - 2017 - Paper 2

4.1.1 Give ONE reason why it would be incorrect for this field to be an integer data type.

4.1.2 Explain why none of the other fields in this table would be a suitable primary key.

4.1.3 Motivate this suggestion.

4.1.4(a) The field that must be added.

4.1.4(b) The table this field must be added to.

Join the NSC students using SimpleStudy...