System Analysis Assignment ERD Name _______________________________________ Please note that all diagrams must be in ONE document. Thanks 1. 2. 3. 4. 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; 2. 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 3. Explain what primary, foreign key and composite keys are in the tables and show a table example demonstrating your knowledge. Explain the sample. 4. Create database tables, group by main groupings, and normalize the table. If an intersecting table is required, 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. Member Number Member Name Coach Years of Experience Coach Last Name Coach First Name Team Name Member Grade Team Color Member School Coaches Ratings James Frank Frank Members First Name Molly Susan Sherri 333-2433 333-2423 222-5644 Patton Rose Day 5 4 3 Schloss Lee Lee Bulls Rebels Rebels 1st 2nd 1st Red Green Green Madison Elm Elm A B B 666-7373 Ferry 5 Schloss Robert Jane Bulls 1st Red Madison A