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?
What will be an ideal response?
Open the database, click on the Database Tools tab on the Ribbon, then click on the Relationships button in the Relationships group. Click the Show Table button in the Relationships group, and click Employees, click Add, click Pay, and click Add, then click Close. Drag the Emp ID field from the Employees table to the Emp ID field in the Pay table. Click the Enforce Referential Integrity check box to add a check mark, and click Create.
You might also like to view...
The Magnetic Media Program, which subsequently became known as the Computer Analysis and Response Team (CART) was established by ________
Fill in the blank(s) with the appropriate word(s).
In an inline style rule, a(n) ____ is included after the value.
A. semicolon B. question mark C. period D. asterisk