ISYS 2263 – Principles of Information Systems | Complete Solution

Instructions: Answer the question below. You should submit to Blackboard your MS Visio
model and a word document that answers Part b below.
a. Using the following data dictionary, create an ERD model within MS Visio. Your model
should include data types, relationships between entities, primary key identification,
and foreign key identification (35 points)
b. Briefly explain why you chose particular types of relationships and cardinalities (15
points)
Table Field Name P/F Key Description Data Type Constraints
MANAGER ManagerID PK Manager Identification
Number
INTEGER NOT NULL
M_FirstName Manager First Name VARCHAR NOT NULL
M_LastName Manager Last Name VARCHAR NOT NULL
M_Address Manager Street Address VARCHAR
M_City Manager Address - City VARCHAR
M_StateAbbr FK Manager Address - State VARCHAR NOT NULL
M_Zip Manager Address – Zip Code VARCHAR
M_Phone Manager Phone Number VARCHAR
STATE State_Abbr PK State Abbreviation VARCHAR NOT NULL
StateName Full State Name VARCHAR NOT NULL
PLAYER PlayerID PK Player Identification Number INTEGER NOT NULL
P_FirstName Player First Name VARCHAR NOT NULL
P_LastName Player Last Name VARCHAR NOT NULL
P_Address Player Street Address VARCHAR
P_City Player Address – City VARCHAR
P_StateAbbr FK Player Address - State VARCHAR NOT NULL
P_Zip Player Address – Zip Code VARCHAR
P_Phone Player Phone Number VARCHAR
TEAM TeamID PK Team Identification Number INTEGER NOT NULL
TeamName Team Name VARCHAR NOT NULL
ManagerID FK Manager Identification
Number
INTEGER
Data Modeling Assignment
Table Field Name P/F Key Description Data Type Constraints
TEAM_PLAYER PlayerID PK, FK Identification Number of Player INTEGER NOT NULL
TeamID PK, FK Identification Number of Team INTEGER NOT NULL
StartDate PK Start Date for Player on the
Team
DATE NOT NULL
EndDate End Date for Player on the
Team
DATE
GAME GameID PK Identification Number for
Game
INTEGER NOT NULL
GameDate Date of the Game DATE
HomeTeamID FK Team Identification of Home
Team
INTEGER NOT NULL
AwayTeamID FK Team Identification of Away
Team
INTEGER NOT NULL
HomeTeamScore Score for Home Team During
Game
INTEGER
AwayTeamScore Score for Away Team During
Game
INTEGER
FieldID FK Field Location for Game INTEGER NOT NULL
FIELD FieldID PK Identification Number for Field INTEGER NOT NULL
F_Name Name of the Field VARCHAR 40
F_Location Street Address of Field VARCHAR 40
F_City City of Field VARCHAR 20
F_StateAbbr FK State of Field VARCHAR 2 NOT NULL
F_Zip Zip Code of Field VARCHAR 10