Database Development and Design

DATABASE DEVELOPMENT AND DESIGN
DATABASE DEVELOPMENT AND DESIGN
Name of the Student
Name of the University
[Class and ID]
Author Note
[Student name] [Student ID] Page 0 of 25

DATABASE DEVELOPMENT AND DESIGN
Table of Contents
Part A...............................................................................................................................................2
1. Business Overview...............................................................................................................2
2. Business requirements..........................................................................................................2
3. Expected project outcomes...................................................................................................3
4. Technical and administrative details....................................................................................3
Part B...............................................................................................................................................5
5. ER diagram...........................................................................................................................5
6. Relation schemas..................................................................................................................6
7. Normal forms the schema satisfies.......................................................................................6
Part C...............................................................................................................................................9
8. Database implementation......................................................................................................9
a. Creating the database........................................................................................................9
b. Creating the tables and their relationships......................................................................11
9. Database testing..................................................................................................................11
c. Populate your database with at least 20 test records.......................................................11
d. Test insertion of records..................................................................................................15
e. Test deletion of records...................................................................................................15
f. Test relationship between the tables...............................................................................15
Bibliography..............................................................................................................................16
[Student name] [Student ID] Page 1 of 25

DATABASE DEVELOPMENT AND DESIGN
Part A
1. Business Overview
The organization Mt Albert football club is a football association that focuses on offering
different opportunities towards the payers and employees. The club has huge number of
players and employees that focuses entirely on providing a better support towards the
activities that are conducted by the clubs. The players are being identified with the help of
their unique player ID that stores all necessary details including names, address and phone
number. The other important employees associated with the club includes physios specialized
in different fields. Each employees associated with the club are being identified with the use
of unique employee ID. The main aim of having physios is to ensure that proper health
conditions are maintained by each payer associated with the club. Each player can have more
physios that will be appointed by their respective coaches. The aim of this assessment is to
design an effective relational database schema that will help in representing the system
information. As a database designer it is important to ensure that all data are implemented
successfully within the database and the developed system is able to meet the needs of the
organization.
2. Business requirements
The client in this organization manly aims at managing the data related to each
employees and players efficiently. The designed database will store all the necessary details
regarding players including their unique ID, name, address, and phone numbers within the
system. This data will help the club to have a clear control over the football association.
Apart from this the developed database will also store the details regarding physios that are
being assessed towards the employees. This will ensure that the information system is able to
[Student name] [Student ID] Page 2 of 25

DATABASE DEVELOPMENT AND DESIGN
address all the necessary data on time. In addition to this the development database will also
store all the essential and unique details regarding each employees.
3. Expected project outcomes
It is expected that with the help of designing a database for Mt Albert football club it will
become easy to manage the data that are stored within the system. The main deliverables that
are associated with the project includes developing a database that will store all the details
associated with the players, employees, coaches and the physicians. This details are essential
and thus it becomes essential to prepare a proper database system that will store all the
information. The project will include database implementation based on the ER diagram and
relational schemas. The second part that will be included within the database includes testing
the developed database and storing the information regarding each activity that takes place
within the club. The ERD will also contain a list of tournaments that are going to be held on
within the club.
4. Technical and administrative details
a. DBMS software used: the software that is being used for creating the database is
MySQL Workbench. The main reason behind using this software is that it provides an
effective visual console towards the administrative MySql environment so that it
becomes easy to gain better visibility towards the database. The ER diagram will be
developed for the purpose of referencing with the MYSQL workbench. This will help at
the time of storing the data regarding the football club. In addition to this the MySql
workbench also offers effective way of managing the backup and recovery plans so that
each data can be maintained securely within the system.
[Student name] [Student ID] Page 3 of 25

DATABASE DEVELOPMENT AND DESIGN
b. Backup: for backup purpose within the database it is important to export the database to
a file within the local system that will be referred to as the data dump. The steps for
performing the backup within the database are listed below:
Step 1: choosing the data export that is listed under the server tab
Step 2: after this the user needs to select the database on which backup function will be
performed
Step 3: After this the user needs to select the tables for performing the export
Step 4: the user needs to choose a location where database backup needs to be saved.
After this the file needs to be export to dump project folder and the database needs to be
included with all the selected tables.
Step 5: after this the user needs to start export and should the password of the database
After all this steeps are executed successfully the user needs to restore the database from
the previously made backup.
Restoring the database
Step1: choosing the database that is to be imported
Step 2: clicking the data import under server tab section
[Student name] [Student ID] Page 4 of 25

DATABASE DEVELOPMENT AND DESIGN
Step 3: entering the database password that is set by the system
Step 4: importing the data from dump project folder
Step 5: after this the user needs to select Import from Self-Contained File and enter the
location in the File Path text field
Step 6: the data gets backed up based on the size and each data gets stored successfully
within the system
c. Recovery plans
With the help of a recovery plan it will become easy to manage the data stored within the
system. The steps that are essential for recovery plan are described below:
Step1: choosing the database that is to be imported
Step 2: clicking the data import under server tab section
Step 3: entering the database password that is set by the system
Step 4: importing the data from dump project folder
Step 5: after this the user needs to select Import from Self-Contained File and enter the
location in the File Path text field
Step 6: the data gets backed up based on the size and each data gets stored successfully
within the system
Part B
5. ER diagram
[Student name] [Student ID] Page 5 of 25