Access tuitorial quesries
•You have contracted with Farmer’s Insurance to build a database to help track policies. Any one policy holder can have more than one policy. Each policy is served by one Sales rep. A rep may serve many policies, however, since Farmer’s has different organizations for Farm and Auto insurance, sometimes a policy holder can be served by more than one rep. This will be done as a team.

•Deliverables
–ERD
–Data Dictionary
–Pictures of each table and the relationship screen
–One query that your team designs
–Pictures of the query
–Enter test data and show me how it works
-Lessons learned page

Access tuitorial quesries
•You have contracted with Farmer’s Insurance to build a database to help track policies. Any one policy holder can have more than one policy. Each policy is served by one Sales rep. A rep may serve many policies, however, since Farmer’s has different organizations for Farm and Auto insurance, sometimes a policy holder can be served by more than one rep. This will be done as a team.

•Deliverables
–ERD
–Data Dictionary
–Pictures of each table and the relationship screen
–One query that your team designs
–Pictures of the query
–Enter test data and show me how it works
-Lessons learned page

Access tuitorial quesries
•You have contracted with Farmer’s Insurance to build a database to help track policies. Any one policy holder can have more than one policy. Each policy is served by one Sales rep. A rep may serve many policies, however, since Farmer’s has different organizations for Farm and Auto insurance, sometimes a policy holder can be served by more than one rep. This will be done as a team.

•Deliverables
–ERD
–Data Dictionary
–Pictures of each table and the relationship screen
–One query that your team designs
–Pictures of the query
–Enter test data and show me how it works
-Lessons learned page