Database Management System for Tennis Match

The assignment provides an in-depth analysis of designing and implementing a database management system for managing tennis matches. It covers topics such as entity relationship diagrams, normalization (1NF, 2NF, 3NF), and SQL queries. The document also includes examples of how to implement these concepts using real-world scenarios.

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

SQL queries:
Match :

Organizer

Player:
Refere ranking

Round

Staff

Student:

Team:

Winner:

Part 3
3. write SQL command and shows the table creations.
a). To show the winner of each game in each round

To sort all teams according to their scores

To provide a report for a referee with all the games he served

To provide a list of the loser teams
To provide a list of all players in all teams

Game scores after each round

The total number of games that each team played in a match

Total score of each team after match
The winner list of all recorded matches

Referees ranking, referee with best performance at all matches