Database System Report: Design, Implementation, and SQL Queries

This report provides a comprehensive overview of a database system designed for managing tennis matches. It begins with an introduction to database management systems and their importance, followed by a detailed exploration of database design using Entity-Relationship (ER) diagrams. The report illustrates the design process with examples of entities such as Match, Player, Organizer, and others, detailing their attributes and relationships. It then delves into database normalization techniques, including 1NF, 2NF, and 3NF, to ensure data integrity and reduce redundancy. The second part of the report focuses on the implementation of the database project, showcasing various tables and their structures. It also presents a series of SQL queries for data manipulation, including inserting, updating, and retrieving information. The final part demonstrates the use of SQL commands to create tables and retrieve specific data, such as showing the winner of each game, sorting teams by scores, providing reports for referees, listing loser teams, and providing player lists. The report also covers game scores, total games played by each team, total scores, winner lists, and referee rankings, providing a complete guide to database system design and implementation for tennis match management.

Introduction to Database system

Table of Contents
INTRODUCTION...........................................................................................................................3
Part 1................................................................................................................................................3
Part 2..............................................................................................................................................11
Part 3..............................................................................................................................................23

INTRODUCTION
Database management system is technique or process for collecting all information
regarding the match. DBMS is necessary for managing the data in proper manner. This report
will discuss about the different techniques and process to control the operations of database
system. This report will describe the tennis match management. There is different employee,
staff and students participating. This database system will help for controlling, updating,
inserting the information.
Part 1
Design database applications
ER Diagrams:
For Example-
Entity-
Match
Attributes-
match_id
match_date

match_time
match_score
match_refere
Entity-
Player
Attributes-
player_id
player_name
player_email
player_contact no
Entity-
organizer
Attributes-
org_id
org_name
org_email address
org_contact no
Entity-
Leader
Attributes-
Leader_id
Leader_name
Leader_contact no
Leader_email address
Entity-
Student
Attributes-
Student_id
Student_name
Student_contact no
Student_email address

Entity-
Staff
Attributes-
Staff_id
Staff_name
Staff_contact no
Staff_email
Entity-
Round
Attributes-
Round_id
Round_type
Entity-
Team
Attributes-
Team_id
Team_name
Entity-
Winner
Attributes
Team_id
Team_name
Entity – Entity is based on real world object and this is also representing as an important part of
database system. Database using entity for representing the relationship between them.
Characteristics of entity:
Entity is an object for building an effective database table and their specific relationship among
them. This is applicable in database for designing the relationship in the form of tables and
columns.
Entities can be categorised in different forms such as
Minor entities
Major entities

For Example- According to design ER model, Leader is entity. It shows particular person
characteristics and their attributes.
Normalization: - normalization is a process which help for designing database tables and
organize data in proper format. Normalization technique is reducing the tables into different
format. This is important technique useful for database management system. This technique is
also useful for reduce the data dependencies and reduce redundancy data.
1NF(Normal Form) :
 Each and Every table contain single value in database tables.
 Each record need to be unique and specific.
s.
This table shows 1NF normal form because this database table contain all information of
staff and they contain unique and single value
2NF(Normal Form):
 Single column has primary key in tables.
 1 NF forms.
3NF(Normal Form):
 This normal form doesn’t have any transitive functional dependencies.

Both
tables contain match_id, it means that could modify to shows only match, player information in
3rd tables.
Match_id can be shown as a functional data dependency in the database tables.

Part 2
2. Implementation of database project