Download Assignment 1 - Database(1622) and more Study Guides, Projects, Research Information Technology in PDF only on Docsity!
ASSIGNMENT 1 FRONT SHEET
Qualification TEC Level 5 HND Diploma in Computing Unit number and title Unit 04: Database Design & Development Submission date 19/02/20 22 Date Received 1st submission Re-submission Date Date Received 2nd submission Student Name Phan Nhat Linh Student ID GCD Class GCD0905 Assessor name Do Duy Thao Student declaration I certify that the assignment submission is entirely my own work and I fully understand the consequences of plagiarism. I understand that making a false declaration is a form of malpractice. Student’s signature (^) Linh Grading grid
P1 M1 D
Summative Feedback: Resubmission Feedback:
Grade: Assessor Signature: Date: Signature & Date:
Table of Contents
CHAPTER I : STATEMENTS OF USER AND SYSTEM REQUIREMENTS
1. Database
1.1 Definition
A database is information that is set up for easy access, management and updating. Computer databases typically store aggregations of data records or files that contain information, such as sales transactions, customer data, financials and product information. Databases are used for storing, maintaining and accessing any sort of data. They collect information on people, places or things. That information is gathered in one place so that it can be observed and analyzed. Databases can be thought of as an organized collection of information.
Figure 1 : Database
1.2 What are databases used for?
Businesses make educated business decisions based on data contained in databases. The following are some examples of how businesses use databases: ➢ Improve the efficiency of your company procedures: Data about business operations such as sales, order processing, and customer support is collected by companies. They use the information to enhance their procedures, develop their company, and increase income. ➢ Keep track of your clients: People's information, such as that of clients or users, is frequently stored in databases. User information such as names, email addresses, and activity is stored in databases on social media sites, for example. The information is utilized to make content recommendations to users and to improve their overall experience. ➢ Personal health information should be kept private: Databases are used by healthcare practitioners to securely store personal health data in order to inform and enhance patient treatment.
4. Requirements of the application
My system will have 2 roles in this program: Coach and footballer.
Coach
- I would like to review the contract details and current contract status.
- I would like to review the details of the players to select the lineup for my upcoming match and campaign.
- I want to see what tournaments my team is playing in to come up with the optimal, suitable method for the matches.
- I want to see the stadium information of the football teams to make the appropriate travel arrangements.
- I want to see the goals scored by the players in the team to reward.
- I want to see information about players of other teams to analyze and prepare for matches. Footballer -^ I want to review my scoring record to strive for each match. ➢ Functionalities:
- Create: Create a new contract when the coach starts signing a contract with the team.
- Read: Read player information.
- Update: Update information on the number of goals scored by the footballer in each match.
- Delete: Delete the entered information.
➢ Advanced Statistics Actions
- Statistics of the top 10 footballers with the most goals.
- Statistics of the top 10 oldest footballers still playing.
- Statistics of the top 10 oldest coaches.
- Entity Relationship Diagram (ERD) of Football management CHAPTER II: DESIGN THE RELATIONAL DATABASE SYSTEM
1. ERD Explanation
➢ Each team will have many coaches such as head coach, goalkeeping coach, fitness coach,... ➢ Each contract will be signed with a coach. But a coach can sign many contracts. For example, in 2010 coach A signed a contract with team B, in 2011 coach A was fired, in 2013 coach A signed a contract with team C. It cannot be ruled out that a coach does not have a contract. ➢ In a team there will be many players, each player only plays for one team. ➢ A football team will have its own stadium, teams with economic potential will have more than one stadium. However, a stadium is only owned by one team ➢ A team will have many enrollment, but a enrollment is only of one team. ➢ One entry is for only one tournament, however multiple entries make up one tournament.
2. Table Description:
The database system has 5 tables, which are:
2.1 Coach table
This table is used to store information of football coaches, this information can help users learn about opponents before matches, in addition, it is also the basis for teams to search for coaches. new member .This table includes: ➢ Coach_ID (PK): This is the primary key of the table to ensure that each trainer has a unique ID that doesn't duplicate ➢ Coach_Name: Save the name of the coach ➢ Coach_Age: Saves coach's age information
Figure 3 : Coach table Figure 4 : Example of Coach table
2. 2 Contract table
This table is used to store information about the coach's contract with the team. ➢ Team_ID (PK, FK): This is the primary key and the foreign key used to refer to Team_ID in the Team table to display the ID of that team. ➢ Coach_ID: This is the primary key and foreign key referenced with Coach_ID in the Coach table as the primary function that allows the team to contract with multiple coaches. ➢ Contract_StartDate: Stores the start date information in the contract. ➢ Contract_EndDate: Stores contract end date information.
Figure 7 : Footballer table Figure 8 : Example of Footballer table
2.4 Team table
This table is used to store general information of the teams, it helps users to have more information about the opponent. This table includes: ➢ Team_ID ( PK ): This is the primary key to identify that a team only has a unique and not duplicate ID. ➢ Team_Name: Store name information of the team ➢ Coach_ID (FK): This is a foreign key that refers to the Contract table. That shows the coach's contract information..
➢ Tournament_ID (FK): This is the foreign key that refers to the Tournament table. That shows what tournaments this team is participating in. ➢ Stadium_ID (FK): This is a foreign key that refers to the Stadium table. That shows the stadium information of this team. Figure 9 : Team table Figure 10 : Example of Team table
2.5 Tournament table
This table is to store information of all tournaments and the countries that host that tournament. This table includes ➢ Tournament_ID (PK): This is the primary key to identify that each tournament has only one unique ID and no duplicates.
➢ Enrollment_StartDate: Stores registration date information. Figure 13 : Enrollment table Figure 14 : Example of Enrollment table
2.7 Stadium table
This table is used to store information of all stadiums, helping opponents and spectators to know the stadium's information, as well as the stadium's address. This table includes: ➢ Stadium_ID (PK): This is the primary key to identify that a stadium has only one unique ID and no duplicates. ➢ Stadium_Name: Stores the name of the stadium. ➢ Stadium_Located: Stores the address information of the stadium.
Figure 15 : Stadium table Figure 16 : Example of Stadium table
