Reference no: EM133785639

Assignment: System Analysis

I. Note that all diagrams must be in ONE document. Thanks

i. Draw the ERD for the following set of tables.
ii. Include all keys (primary and functional keys (note FK are missing in the tables)
iii. Note that the table below may contain errors so make corrections where necessary.
iv. If the table does not contain a primary key, 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;

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

Include the primary and functional keys
Member table
Member Status Table
Checking Transaction Table
Checking Transaction Types
Member State Table

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

IV. 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.