This Is My Proposali Am A Big Fan Of An Online Game Which We Can It L This is my proposal: I am a big fan of an online game which we can it League of Legends and I play this game very often. I want to create a database which base on my favorite teams and analysis how did they won or lost each game. I believe it’s going to help me to improve both my game skill and database design skill. I think it is going to be very fun because I love both DSS and LOL. Project Assignment: The project applies all the concepts of database design and applications learned in this course. You should use at least three tables that implement integrity rules. The tables should be related to each other. You should create at least one report in Excel, three queries, two view, and two PL/SQL programs with at least one of them using prompt variables. Outline of the Paper for the Project: I. Introduction - defines the scope of the project. II. Design - for logical design (normalization) and other physical-level design considerations. III. Implementation - description of tables, reports, views, and other PL/SQL programs. IV. Conclusion - what you have achieved, shortcomings, and scope for improvements.
Paper For Above instruction Introduction The proliferation of online multiplayer games has led to a significant increase in data generation related to gameplay statistics, player performance, team strategies, and match outcomes. Among these, League of Legends (LoL), one of the most popular online competitive games, offers extensive opportunities for data collection and analysis. This project aims to develop a comprehensive database system to analyze the performance of favorite teams, understand the underlying factors influencing match outcomes, and utilize database management concepts to optimize the data insights. The scope includes the creation of relational tables representing teams, matches, player statistics, and game outcomes, with the ultimate goal to enhance strategic understanding of LoL gameplay through data analysis. Design The core of this project involves logical and physical database design, emphasizing normalization to reduce redundancy and ensure data integrity. The primary entities identified include Teams, Matches, and Players. Each entity is represented as a separate table with specific attributes; for example, the Teams table includes team names and IDs, the Matches table records match details such as date, participating teams, and outcomes, and the Players table tracks individual player statistics. To ensure data consistency, integrity rules such as primary keys, foreign keys, and check constraints are implemented. Relationships between