Identify and describe the components of the table shown in Figure Q3.21, using correct terminology. Use your knowledge of naming conventions to identify the table's probable foreign key(s).
Figure 03.21: The Ch03_NoComp Database Employee Table
Table name: EMPLOYEE
Database name: Ch03_NoComp
EMP_NUM | EMP_LNAME | EMP_INITIAL | EMP_FNAME | DEPT_CODE | JOB_CODE
11234 | Friedman | K | Robert | MKTG | 12
11238 | Olanski | D | Delbert | MKTG | 12
11241 | Fontein | Juliette | INFS | 5
11242 | Cruazona | J | Maria | ENG | 9
11245 | Smithson | B | Bernard | INFS | 6
11248 | Washington| G | Oleta | ENGR | 8
11256 | McBride | Randall | ENGR | 8
11257 | Kachinn | D | Melanie | MKTG | 14
11258 | Smith | W | William | MKTG | 14
11260 | Ratula | A | Katrina | INFS | 5