1. Draw the ERD for the following set of tables. Member (member id, name, address, city, zip, state, team, ID) Team (team ID, team name, team division, team color, team captain, team grade, coach ID ) Division (Division ID, division grade, division coordinator, division town) City (City ID, town, zip, town name) Coach (Coach ID, First Name, Last Name) Members belongs to teams. Teams are in divisions. Please note coaches can coach more than one team.

2. Create tables for the checking application. Include the attributes and relationships. Member table Member Status Checking Transaction Table Checking Transaction Types Member State Table

3. Explain what primary, foreign key and composite keys are in the tables and show a table example demonstrating your knowledge.