INSTRUCTION: Use the scenario below to answer the questions that follows:

You have been asked to create a database for a company in Kingston. The purpose of the database is to track employees and the departments for which the employees work. A department can have between 5 and 15 employees. You have determined that you need the following TWO (2) tables:

Table1: Employee (TRN Number, Employee Name, Street Address, Town, Parish, Date Hired, Salary, Department Code)

Table2: Department (Department Code, Department Name)

Case 1 Primary Key

Which field in the Employee table should be the primary key and why? (3 marks)

Which field in the Department table should be the primary key and why? (3 marks)

Case 2 Data Types

Now that you have created the tables and determined the primary and foreign keys, you need to determine the data types for the fields in each table.

(a) What data type will you use for the Salary field? Why? (3 marks)

(b) What data type will you use for the TRN Number field? Why? (3marks)

Case 3 Relationships

(a) What fields are used in the creation of relationships in MS Access? And why are relationships important? (3 marks)

(b) How would you join the two (2) tables given above? (3 marks)

(c) What improvements could you make to the table (s) (2 marks)