Other Question
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+
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
