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.
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller sidx. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £8.19. You're not tied to anything after your purchase.
