Cashback Offer from 10th to 18th May 2021. Get Flat 20% Cashback credited to your account for a minimum transaction of $80. Post Your Question Today!

Question DetailsNormal
$ 24.00

ISYS 2263 – Principles of Information Systems | Complete Solution

Question posted by
Online Tutor Profile
request

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

Available Answer
$ 24.00

[Solved] ISYS 2263 – Principles of Information Systems | Complete Solution

  • This solution is not purchased yet.
  • Submitted On 01 Nov, 2015 12:22:42
Answer posted by
Online Tutor Profile
solution
• Player and State Like above relationship, a player can be from a single state only while there ...
Buy now to view the complete solution
Other Similar Questions
User Profile
Homew...

ISYS 2263 – Principles of Information Systems | Complete Solution

• Player and State Like above relationship, a player can be from a single state only while there can be zero or more players in a state. So there is zero or one-to-many relationship between them. • State and Field Like ab...

The benefits of buying study notes from CourseMerit

homeworkhelptime
Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
tutoring
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
tutorsupport
Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
closebutton

$ 629.35