Question

Assignment Definition:

Use the data model you designed in Week 2 (ERD Diagram Definition). This data model will be reviewed and taken from the conceptual model to logical model status.

Conceptual data modeling is about understanding the organization – getting the right requirements built into the database design.

Logical data modeling is about creating stable database structures – expressing the organizational requirements correctly in a technical language so that the resulting database operates on a specific type of database technology.

scenario – A Local Football League You have been asked to develop a database to maintain details of the football teams signed up to play in a local league, including the schedule. The database must maintain details of the name and location of each team, and for each team the players (and their positions) who are on the team. So that a handicap system can be developed later the database should maintain the gender, and age of each player. Each player should also have one 'phone number stored. Schedule and field locations for each of the games the teams will play.

Make sure you define the following:

1. All entities and relationships among them.
2. Specify all attributes for each entity.
3. Specify the primary key for each entity.
4. Specify Foreign keys (keys identifying the relationship between different entities).
5. Review data model to make sure data model is in at least 3rd normal form (as defined by the normalization process).
6. Create a logical data model of your scenario.

Answer 1