Question
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
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started