Introduction of DBMS (Database Management System)

Running head: INTRODUCTION TO DATABASE SYSTEMS
INTRODUCTION TO DATABASE SYSTEMS
Name of the Student
Name of the University
Author Note

1
INTRODUCTION TO DATABASE SYSTEMS
List of Business Rules
The business rules for to be followed for the development of the database are:
 The system should be able to store the details of the team along with the information
about the ranks and the members of the system.
 The system should also store the details of the games and the rounds which would takes
place.
 The details of the winners are also required to be stored in the system.
Entities along with the relationship in the system
TeamDetails (TeamID (pk), TeamName, LeaderID (fk), Members, Rank)
Student (StudentID (pk), StudentName , StudentAddress, TeamID(fk), LeaderID(fk))
Staff (LeaderID (pk), StaffName, TeamID (fk), Staff_address)
Winner details (Winner_ID (pk), Team_ID (fk), Score, Yearofwinning)
Referee (RefereeID (pk), RefName, RefContact, RefName, RefScore)
Result (Rank (pk), TeamID (fk), TeamScore)
Game details (ID (Pk), TeamID (fk), ScoreDetails, Roundnumber(fk))
Round details (RoundNumber(pk), RoundName, Roundtime , RefereeID (fk))

2
INTRODUCTION TO DATABASE SYSTEMS
Characteristics of the system
The system consists of 8 major entities which would be useful for description of the
system. In addition to this, attributes are to be linked with each other so that the relationships
would be helpful in getting the entire details of a particular record.
ER diagram for the system
ERD model table structures
Entities Attributes
Student StudentID
StudentName
StudentAddress

3
INTRODUCTION TO DATABASE SYSTEMS
TeamID
LeaderID
Staff LeaderID
StaffName
TeamID
Staff_address
Team details TeamID
TeamName
LeaderID
Members
Rank
Winner details Winner_ID
Team_ID
Score
Yearofwinning
Referee RefereeID
RefName
RefContact
RefName
RefScore
Result Rank
TeamID

4
INTRODUCTION TO DATABASE SYSTEMS
TeamScore
Game details ID
TeamID
ScoreDetails
RoundNumber
Round details RoundNumber
RoundName
RoundTime
RefereeID
3NF dependency
Dependencies Attributes
StudentID StudentName, StudentAddress, TeamID, LeaderID
TeamID TeamName, LeaderID, Members, Rank
LeaderID StaffName, TeamID, Staff_address
Winner_ID Team_ID, Score, Yearofwinning
RefereeID RefName, RefContact, RefName, RefScore
Rank TeamID, TeamScore
ID, TeamID ScoreDetails, Roundnumber
RoundNumber RoundName, Roundtime , RefereeID

5
INTRODUCTION TO DATABASE SYSTEMS
Data dictionary
Entities Attributes Data type Key
Student StudentID Number Primary Key
StudentName Varchar
StudentAddress Varchar
TeamID Number Foreign Key
LeaderID Varchar
Staff LeaderID Number Primary Key
StaffName Varchar
TeamID Number Foreign Key
Staff_address Varchar
Team details TeamID Number Primary Key
TeamName Varchar
LeaderID Number Foreign Key
ID Number Foreign Key
Members Varchar
Rank Number
Winner details WinnerID Number Primary Key
TeamID Number Foreign Key
Score Number
Yearofwinning Date
Referee RefereeID Number Primary Key