Exam (elaborations)

Database

0 purchase

Module
BTECH

Institution
PEARSON (PEARSON)

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.

[Show more]

Preview 3 out of 28 pages

View example

Uploaded on July 19, 2022
Number of pages 28
Written in 2018/2019
Type Exam (elaborations)
Contains Questions & answers

advance programming
business intelligence
cloud computing
database
operating system
rese
application program interface
data structures amp algorithm
design amp develop
managing successful business

Study Level BTEC
Examinator PEARSON (PEARSON)
Subject Level 5
Unit BTECH

£8.16

Also available in package deal from £32.67

Add to cart

Add to wishlist

100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached

Also available in package deal (1)

Northumbria university Level 4-5

£ 97.94 £ 32.67 12 items

1. Exam (elaborations) - Security
2. Exam (elaborations) - Implementing information system (it) in security
3. Exam (elaborations) - Implementing information system (it) in security
4. Exam (elaborations) - Operating system (os)
5. Exam (elaborations) - Managing successful business
6. Exam (elaborations) - Design and develop (website)
7. Exam (elaborations) - Data structures & algorithm
8. Exam (elaborations) - Database
9. Exam (elaborations) - Cloud computing
10. Exam (elaborations) - Business intelligence
11. Exam (elaborations) - Application program interface
12. Exam (elaborations) - Advance programming
Show more

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.16. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69411 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy revision notes and other study material for 15 years now

Start selling