Please note that all diagrams must be in ONE document. Thanks

Draw the ERD for the following set of tables.

Please include all keys $($primary and functional keys $($please note FK are missing in the tables$)$

Please note that the table below may contain errors so make corrections where necessary.

If the table does not contain a primary key, please include it$)$

Member $($Member id$,$ name, address, city, zip, state, country$)$

Team $($team ID$,$ team name, team division, team color, team captain, team grade $)$

Division $($Division ID$,$ division grade, division coordinator$)$

Coach $($Coach ID$,$ First Name, Last Name, Coach Ratings$)$

Members belongs to teams. teams are in divisions. Coaches can coach many teams;

Create the following tables for the bank checking application. Include the attributes and relationships.

Please include the primary and functional keys

Member table

Member Status Table

Checking Transaction Table

Checking Transaction Types

Member State Table

Explain what primary, foreign key and composite keys are in the tables and show a table example

demonstrating your knowledge. Explain the sample.

Create database tables, group by main groupings, and normalize the table. If an intersecting table is re$-$

quired, please include that. Also please include primary and foreign keys. IF the table does not have a primary key, please

create one. Please show how the tables are connected. Hint team and Last name cannot be primary keys.