You have a database that contains information about all of the employees from your company. There is a table containing basic demographic information called Employees and a table containing salary information called Pay. The two tables are related by the field called Emp ID.
The database contains multiple tables, which have not been used together up to this point. How do you create the relationship between employees and their pay?

Question

You have a database that contains information about all of the employees from your company.  There is a table containing basic demographic information called Employees and a table containing salary information called Pay. The two tables are related by the field called Emp ID. 
 The database contains multiple tables, which have not been used together up to this point. How do you create the relationship between employees and their pay?

Quizplus · Accepted Answer

The Answer of You have a database that contains information about all of the employees from your company.  There is a table containing basic demographic information called Employees and a table containing salary information called Pay. The two tables are related by the field called Emp ID. 
 The database contains multiple tables, which have not been used together up to this point. How do you create the relationship between employees and their pay?

You Have a Database That Contains Information About All of the Employees