Question 2 1. Consider figure 2 below and answer the following questions a. Column emlployee_id is described as a primary key, explain what this means. b. Give examples of data values for each of the data types depicted in the Figure 2. Data type Example values int 1236 c. Which data model is presented in Figure 2? d. With the aid of a diagram, describe any two data models. Table Colum Data Type References Source Required Sensitive Values Description employees employee_id int Auto Primary key of a table employees first_name nvarchar(50) HRM Y Y Employee first name employees last_name nvarchar(50) HRM Y Y Employee last name employees nin nvarchar(15) HRM Y Y National Identification employees position nvarchar(50) HRM Current position title employees department_id int departments HRM Employee department employees gender Char(1) HRM Y M-Male, F-Female, O Employee gender employees employment_start_date date HRM Y Start date of employment in organization Employees employment_end_date date HRM Employment end date Figure 2: Diagram 2
Question 2
1. Consider figure 2 below and answer the following questions
a. Column emlployee_id is described as a primary key, explain what this means.
b. Give examples of data values for each of the data types depicted in the Figure 2.
|
Data type |
Example values |
|
int |
1236 |
|
|
|
|
|
|
c. Which data model is presented in Figure 2?
d. With the aid of a diagram, describe any two data models.
|
Table |
Colum |
Data Type |
References |
Source |
Required |
Sensitive |
Values |
Description |
|
employees |
employee_id |
int |
|
Auto |
|
|
|
Primary key of a table |
|
employees |
first_name |
nvarchar(50) |
|
HRM |
Y |
Y |
|
Employee first name |
|
employees |
last_name |
nvarchar(50) |
|
HRM |
Y |
Y |
|
Employee last name |
|
employees |
nin |
nvarchar(15) |
|
HRM |
Y |
Y |
|
National Identification |
|
employees |
position |
nvarchar(50) |
|
HRM |
|
|
|
Current position title |
|
employees |
department_id |
int |
departments |
HRM |
|
|
|
Employee department |
|
employees |
gender |
Char(1) |
|
HRM |
|
Y |
M-Male, F-Female, O |
Employee gender |
|
employees |
employment_start_date |
date |
|
HRM |
Y |
|
|
Start date of employment in organization |
|
Employees |
employment_end_date |
date |
|
HRM |
|
|
|
Employment end date |
Figure 2: Diagram 2
Step by step
Solved in 2 steps with 3 images
