Database

UNIT NO. & TITLE: NO. 4, Database Design & Development.


QUALIFICATION: BTEC Level 4 Computing


YEAR: 2018-2019


PREPARED BY: Siddhesh Raje


SUBMISSION TYPE: Report


SUBMITTED ON:




Sr.N Topic Page

1

, o No.
1. 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.
M1: Produce a comprehensive design for a fully functional
system which includes interface and output designs, data
validations and data normalisation.
2. LO2: Develop a fully functional relational
database system, based on an existing system
design.
P2: Develop the database system with evidence of user
interface, output and data validations, and querying across
multiple tables.
P3: Implement a query language into the relational database
system.
M2: Implement a fully functional database system which
includes system security and database maintenance
M3: Assess whether meaningful data has been extracted
through the use of query tools to produce appropriate
management information.
3. LO3: Test the system against user and system
requirements.
P4: Test the system against user and systems requirements.
M4: Assess the effectiveness of the testing, including an
explanation of the choice of test data used.
4. LO4: Produce technical and user documentation
P5: Produce technical and user documentation.
M5: Produce technical and user documentation for a fully
functional system, including diagrams showing movements
of data through the system, and flowcharts describing how
the system works.
LO1 Use an appropriate design tool to design a relational database system for a
substantial problem.



2

, 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.




Database: A database is a systematic collection of data databases support
storage and manipulation of data. In simple words data can be facts related to an
object.




Tools used for database
 We have used phpMyAdmin to handle the administration of MySQL
database server.
 We have used phpMyAdmin to perform most administration tasks,
including creating a database, running queries, and manipulating data.


Techniques used for database:
 We have used phpMyAdmin to manipulate database
 We have used our SQL language in phpMyAdmin


Interrelated table:
 In our database to satisfy user requirement our database is joint to each
other
 In our Database Computing level 3 and level 4 are connect.




3