Access Concept Homework

Name:

Read each table, then answer the questions:

Employee Table

$\backslash$table$[[$Employee$,$ID Last Name First Name Address,,City,State Zip,$],[23,$Rivera,Haydee,$325$ Twiddy St$.,$Avondale IL$,60311,],[25,$Simson,Mark,$1476$ Hartwell St$.$ Walker,IN$,46004,],[26,$Lu$,$Peter,$5624$ Murray Ave. Davidson IN$,46007,,],[27,$Murowski,Karen,,$168$ Truesdale Dr$.$ Carlton,IL$,60313]]$

Which field is the primary key in Employee Table?

$\backslash$table$[[$Salary Table,$],[$Employee ID$,$Salary$],[23,2900],[25,3500],[26,3100],[27,4200]]$

Which field can be the primary key in Salary Table?

Can you create relationship between those two tables?

What type the relationship between those two tables?