List all fields that are totally dependent on the PK fields (emp_id and lang_id): 2. List...

  

Transcribed Image Text:

List all fields that are totally dependent on the PK fields (emp_id and lang_id): 2. List all fields that have partial dependence (on one or the other PK fields), and tell which of the PK fields it is dependent on: 3. List all fields that have transitive dependence, and tell which field it is dependent on: At AI Global, we keep track of employee languages, because that can be an important consideration for many projects. The table below is data collected about some of our employees. The last_name field is the employee's last name. Employees belong to a particular department, indicated by the id and department name. Language information includes id, the name of the language, and its degree of difficulty (ranging from 1-5). When an employee is formally certified in a particular language, they have a certification date and certification score. Some data is included int the table below. The table is in INF. The composite PK consists of emp_id and lang_id. emp id last name dept id cert date. dept name lang id 1 Blaine 11 9/5/2021 101 Thomas 12 6/12/2019 100 13 4/15/2015 100 12 12/4/2020 102 14 103 11 104 12 103 13 101 15 104 2 3 2 5 6 3 7 Silva Thomas Chou Stanley Cherry Silva Henry HR IT Acct. IT Marketing HR IT Acct. 11/11/2019 Finance 2/22/2016 8/16/2021 6/6/2017 lang name cert score difficulty French 88 2 Spanish 1 Spanish Italian Mandar German Mandarin French German 92 78 97 75 81 90 79 92 1 2 5 3 5 2 3 List all fields that are totally dependent on the PK fields (emp_id and lang_id): 2. List all fields that have partial dependence (on one or the other PK fields), and tell which of the PK fields it is dependent on: 3. List all fields that have transitive dependence, and tell which field it is dependent on: At AI Global, we keep track of employee languages, because that can be an important consideration for many projects. The table below is data collected about some of our employees. The last_name field is the employee's last name. Employees belong to a particular department, indicated by the id and department name. Language information includes id, the name of the language, and its degree of difficulty (ranging from 1-5). When an employee is formally certified in a particular language, they have a certification date and certification score. Some data is included int the table below. The table is in INF. The composite PK consists of emp_id and lang_id. emp id last name dept id cert date. dept name lang id 1 Blaine 11 9/5/2021 101 Thomas 12 6/12/2019 100 13 4/15/2015 100 12 12/4/2020 102 14 103 11 104 12 103 13 101 15 104 2 3 2 5 6 3 7 Silva Thomas Chou Stanley Cherry Silva Henry HR IT Acct. IT Marketing HR IT Acct. 11/11/2019 Finance 2/22/2016 8/16/2021 6/6/2017 lang name cert score difficulty French 88 2 Spanish 1 Spanish Italian Mandar German Mandarin French German 92 78 97 75 81 90 79 92 1 2 5 3 5 2 3 List all fields that are totally dependent on the PK fields (emp_id and lang_id): 2. List all fields that have partial dependence (on one or the other PK fields), and tell which of the PK fields it is dependent on: 3. List all fields that have transitive dependence, and tell which field it is dependent on: At AI Global, we keep track of employee languages, because that can be an important consideration for many projects. The table below is data collected about some of our employees. The last_name field is the employee's last name. Employees belong to a particular department, indicated by the id and department name. Language information includes id, the name of the language, and its degree of difficulty (ranging from 1-5). When an employee is formally certified in a particular language, they have a certification date and certification score. Some data is included int the table below. The table is in INF. The composite PK consists of emp_id and lang_id. emp id last name dept id cert date. dept name lang id 1 Blaine 11 9/5/2021 101 Thomas 12 6/12/2019 100 13 4/15/2015 100 12 12/4/2020 102 14 103 11 104 12 103 13 101 15 104 2 3 2 5 6 3 7 Silva Thomas Chou Stanley Cherry Silva Henry HR IT Acct. IT Marketing HR IT Acct. 11/11/2019 Finance 2/22/2016 8/16/2021 6/6/2017 lang name cert score difficulty French 88 2 Spanish 1 Spanish Italian Mandar German Mandarin French German 92 78 97 75 81 90 79 92 1 2 5 3 5 2 3 List all fields that are totally dependent on the PK fields (emp_id and lang_id): 2. List all fields that have partial dependence (on one or the other PK fields), and tell which of the PK fields it is dependent on: 3. List all fields that have transitive dependence, and tell which field it is dependent on: At AI Global, we keep track of employee languages, because that can be an important consideration for many projects. The table below is data collected about some of our employees. The last_name field is the employee's last name. Employees belong to a particular department, indicated by the id and department name. Language information includes id, the name of the language, and its degree of difficulty (ranging from 1-5). When an employee is formally certified in a particular language, they have a certification date and certification score. Some data is included int the table below. The table is in INF. The composite PK consists of emp_id and lang_id. emp id last name dept id cert date. dept name lang id 1 Blaine 11 9/5/2021 101 Thomas 12 6/12/2019 100 13 4/15/2015 100 12 12/4/2020 102 14 103 11 104 12 103 13 101 15 104 2 3 2 5 6 3 7 Silva Thomas Chou Stanley Cherry Silva Henry HR IT Acct. IT Marketing HR IT Acct. 11/11/2019 Finance 2/22/2016 8/16/2021 6/6/2017 lang name cert score difficulty French 88 2 Spanish 1 Spanish Italian Mandar German Mandarin French German 92 78 97 75 81 90 79 92 1 2 5 3 5 2 3

Answer rating: 100% (QA)

Based on the information provided in the two images the task is to analyze the dependencies of fields in a database table on the primary key PK fields ... View the full answer