UNIT NO. & TITLE: NO. 4, Database Design & Development.
QUALIFICATION: BTEC Level 4 Computing
YEAR: 2019-2020
PREPARED BY: Kunwar Singh
SUBMISSION TYPE: Report
ASSESSOR NAME: Mr. Kapil Wagehla
SUBMITTED ON:
1
, Index
Sr.No Topic Page
No.
1. LO1: Use an appropriate design tool to design a 3
relational database system for a substantial problem.
P1: Design a relational database system using appropriate 3
design tools and techniques, containing at least four
interrelated tables, with clear statements of user and systems
requirements.
M1: Produce a comprehensive design for a fully functional 6
system which includes interface and output designs, data
validations and data normalisation.
2. LO2: Develop a fully functional relational 12
database system, based on an existing system
design.
P2: Develop the database system with evidence of user 12
interface, output and data validations, and querying across
multiple tables.
P3: Implement a query language into the relational database 16
system.
M2: Implement a fully functional database system which 19
includes system security and database maintenance
M3: Assess whether meaningful data has been extracted 23
through the use of query tools to produce appropriate
management information.
3. LO3: Test the system against user and system 29
requirements.
P4: Test the system against user and systems requirements. 29
M4: Assess the effectiveness of the testing, including an 32
explanation of the choice of test data used.
4. LO4: Produce technical and user documentation. 38
P5: Produce technical and user documentation. 38
M5: Produce technical and user documentation for a fully 42
functional system, including diagrams showing movements
of data through the system, and flowcharts describing how
the system works.
5. References 51
2
, TASK ONE
LO1: Use an appropriate design tool to design a relational database system
for a substantial problem.
P1: Design a relational database system using appropriate design tools and
techniques, containing at least four interrelated tables, with clear
statements of user and systems requirements.
Tools for Relational Database:
1. For storing data into the database, its creation and administration we need
some tools like phpMyAdmin, dbForge Studio for MYSQL, etc.
2. The most popular database tool is phpmyAdmin it is an open source
MYSQL manager.
3. PhpMyAdmin runs in XAMPP Server.
Technique for a relational database system:
We are using phpMyAdmin tools for designing a relational database. We need
to use SQL language to access and manipulate database.
Interrelated table according to the user requirements:
1. In this database we have created 4 tables which are interrelated to each
other. The information stored into the database is organized and all the
tables can communicate with each other.
2.
In this database 2 tables business level 3, 4 are connected.
The above query is used to count how many of students are there in business it
is known by connecting both the tables of level3 & level4 through Union and
displaying output in the column name of total no of students in business.
3
, This is the output of the query implemented. The first row ‘14’ is total no. of
students in business level 3 and the second row ‘17’ is total no. of students in
business level 4.
The above query shows that connecting subject table for level 3& 4 we get to
know that total no of subjects they studied in sem2.
This is the output of the query implemented.
User Requirements:
According to our clients that is E-Cube Global College their requirements are as
follows:
1. It includes that no one should operate the database of E-Cube Global
College expect the data administrator so the privilege should be provided
to some.
2. The database should be managed and organized properly no data should
be deleted which is important for the college.
3. Continuous backup of the data should be taken.
4. Maintenance of the database on regular basis is mandatory.
5. Every user should have password so that security for the database is
maintained.
4
QUALIFICATION: BTEC Level 4 Computing
YEAR: 2019-2020
PREPARED BY: Kunwar Singh
SUBMISSION TYPE: Report
ASSESSOR NAME: Mr. Kapil Wagehla
SUBMITTED ON:
1
, Index
Sr.No Topic Page
No.
1. LO1: Use an appropriate design tool to design a 3
relational database system for a substantial problem.
P1: Design a relational database system using appropriate 3
design tools and techniques, containing at least four
interrelated tables, with clear statements of user and systems
requirements.
M1: Produce a comprehensive design for a fully functional 6
system which includes interface and output designs, data
validations and data normalisation.
2. LO2: Develop a fully functional relational 12
database system, based on an existing system
design.
P2: Develop the database system with evidence of user 12
interface, output and data validations, and querying across
multiple tables.
P3: Implement a query language into the relational database 16
system.
M2: Implement a fully functional database system which 19
includes system security and database maintenance
M3: Assess whether meaningful data has been extracted 23
through the use of query tools to produce appropriate
management information.
3. LO3: Test the system against user and system 29
requirements.
P4: Test the system against user and systems requirements. 29
M4: Assess the effectiveness of the testing, including an 32
explanation of the choice of test data used.
4. LO4: Produce technical and user documentation. 38
P5: Produce technical and user documentation. 38
M5: Produce technical and user documentation for a fully 42
functional system, including diagrams showing movements
of data through the system, and flowcharts describing how
the system works.
5. References 51
2
, TASK ONE
LO1: Use an appropriate design tool to design a relational database system
for a substantial problem.
P1: Design a relational database system using appropriate design tools and
techniques, containing at least four interrelated tables, with clear
statements of user and systems requirements.
Tools for Relational Database:
1. For storing data into the database, its creation and administration we need
some tools like phpMyAdmin, dbForge Studio for MYSQL, etc.
2. The most popular database tool is phpmyAdmin it is an open source
MYSQL manager.
3. PhpMyAdmin runs in XAMPP Server.
Technique for a relational database system:
We are using phpMyAdmin tools for designing a relational database. We need
to use SQL language to access and manipulate database.
Interrelated table according to the user requirements:
1. In this database we have created 4 tables which are interrelated to each
other. The information stored into the database is organized and all the
tables can communicate with each other.
2.
In this database 2 tables business level 3, 4 are connected.
The above query is used to count how many of students are there in business it
is known by connecting both the tables of level3 & level4 through Union and
displaying output in the column name of total no of students in business.
3
, This is the output of the query implemented. The first row ‘14’ is total no. of
students in business level 3 and the second row ‘17’ is total no. of students in
business level 4.
The above query shows that connecting subject table for level 3& 4 we get to
know that total no of subjects they studied in sem2.
This is the output of the query implemented.
User Requirements:
According to our clients that is E-Cube Global College their requirements are as
follows:
1. It includes that no one should operate the database of E-Cube Global
College expect the data administrator so the privilege should be provided
to some.
2. The database should be managed and organized properly no data should
be deleted which is important for the college.
3. Continuous backup of the data should be taken.
4. Maintenance of the database on regular basis is mandatory.
5. Every user should have password so that security for the database is
maintained.
4
