in cis 260

CIS 260: Database Systems Course Project - Fall Semester 2021-2022 Database Requirements The data requirements are summarized as follows: A database is being constructed to keep track of the teams and games of a sports league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of the players participating in each game for each team, the positions they played in that game, and the result of the game. 1. Choose your favorite sport (e.g., soccer, baseball, football). 2. Note any unspecified requirements, and make appropriate assumptions to make the specification complete. Project Duties: Phase I: Study and analyze the given system requirement then do the following: 1) Identify the possible Entities and draw the initial conceptual schema (Level 0) using ER data model. 2) Identify the possible attributes for each entity and refine the initial conceptual schema (Level 1). 3) Identify the possible Relationships between entities and refine the conceptual schema (Level 2). 4) Identify the possible constraints (Cardinality and Participation) for each Relationship and refine the conceptual schema (Level 3). 5) Remove any redundant attribute and refine the conceptual schema (Level 3). 6) Draw the Final Possible Conceptual Schema Using the standard ER notations. Use and drawing tool of your choice (Smart Draw, DB Designer, ER-Win, etc...........). 7) Draw the Final Possible Conceptual Schema Using the standard UML notations. Use and drawing tool of your choice (Smart Draw, DB Designer, ER-Win, Rational Rose, etc ............). Phase II: Map the final ER schema into its equivalent Relational Schema 1) Map entities (Level 0). 2) Map Relationships (Level 1). 3) Map Multivalued Attributes (Level 2). 4) Draw the Final Relational Schema. Phase III: Map the final Relation schema into its equivalent SQL commands 1) Build the Relations/Tables using MS-Access or Oracle-SQL * PLUS tools. 2) Insert at least 5 tuples with real and meaningful values in each table. Provide the SQL DDL commands used to insert the tuples. Phase IV: Database Manipulation: 1) Provide at least 10 SQL queries (SELECT) of your choice that could be used to navigate the built database. Show the results for each query. You can use MS-Access or Oracle-SQL * PLUS tools