Assignment

User Generated

fenizrqv

Computer Science

Description

One document is the assignment work and the other document is week 2 work with this need to be done

Unformatted Attachment Preview

Assignment Definition: Use the data model designed in Week 2. This data model will be reviewed and taken from the conceptual model to logical and physical model status. Make sure you define the following: 1. Select just database management system no need of doing(Oracle, SQL Server, MYSQL, etc) and identify the data types and sizes for all attributes. 2. Make sure all relationships have been addressed and corrected. 3. Review data model to make sure data model is in at least 3rd normal form (as defined by the normalization process). Running Head: A LOCAL FOOTBALL LEAGUE SCENARIO 2 – A LOCAL FOOTBALL LEAGUE Sravan Kumar Prof. Michael Morris IST-7000 Data Management Wilmington University DATE: SUNDAY, JULY 16, 2017 1 A LOCAL FOOTBALL LEAGUE Entity Relationship Diagram for A local Football database Entities to be modeled in A LOCAL FOOTBALL LEAGUE database The following shows the identified entities include: i. TEAM ii. GAME iii. LEAGUE iv. PLAYER v. LEAGUE TEAM PLAYER Attributes associated with each of the entity. The following attributes are associated with the respective TEAM: TEAMID, LOCATION AND NAME GAME: GAMEID, SCHEDULE, FIELD 2 A LOCAL FOOTBALL LEAGUE 3 LEAGUE: LEAGUEID, NAME LEAGUE TEAM PLAYER: PLAYERID AND LEAGUEID PLAYER: PLAYERID, GENDER, DOB, PHNO The entity relationship Team and player relationship is one is to many as many player can join one team and not vice versa Player and League Team Player is also one is to many relationship League Team Player and League is a many to one relationship. League and game is a one to many relationship Primary keys The following are identified primary key TeamID PlayerID LeagueID GameID A LOCAL FOOTBALL LEAGUE Business rules or assumptions made That for any team to play any game there must be at least 11 players apart from other. Each of the player must give out details that identify him. The game rules and regulation must be set and followed.(Shouhong Wang, 2013) 4 A LOCAL FOOTBALL LEAGUE 5 Reference J. Paredaens, L. T. (2014). Advances in Database Systems: Implementations and Applications. Springer: Springer. Shouhong Wang, H. W. (2013). Business Database Technology: An Integrative Approach to Data Resource Management with Practical Project Guides, Presentation Slides, Answer Keys to Hands-on Exercises for Students in Business Programs. Universal-Publishers.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

working...


Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags