Summary
Summary unit 18
- Module
- Unit 18 - Database Design
- Institution
- PEARSON (PEARSON)
Summary of 20 pages for the course Unit 18 - Database Design at PEARSON (unit 18)
[Show more]
Seller
Follow
Content preview
Assignment front sheetCriteria To achieve the criteria the evidence must show that Page
Task no. Evidence
reference the student is able to: no
Design
P2 design a relational database for a specified user need Task 1 documentation
P3 create and populate a database Task 2 Database
create features in data entry forms to ensure validity and integrity Task 2
P4 Entry forms
of data
Task 3 At least 3
P5 perform queries using multiple tables and multiple criteria
Queries
Task 2
M2 import data from an external source Imported data
Learner name Assessor Name
Omit Ali Nas Akhter
Date issued Hand in deadline Submitted on
15/03/2021 02/04/2021
Resubmission (out) (if applicable) Resubmission (in) Lead IV authorisation
NZG
Qualification Unit number and title
Level 3 BTEC National Subsidiary Diploma in IT Unit 18 – Database design
Assignment title 18.2 Designing, creating and populating a relational database
Assignment brief
Scenario
The next part of your teaching practice is to provide an example of a working relational database. You will
have to provide several examples of evidence showing the processes from design to populating your
database.
For the purpose of this assignment you can choose either
an example database of a travel company arranging everything from Grand Prix tickets to
hotel bookings for a motor racing F1 fan
OR an example database for a local gymnasium/health club with membership details and records of
all activities/facilities used
You will have to provide data to be used in a mail merge letter to send to either the motor racing
fan or the member of the health club.
Task 1 – P2
Considering the information you provided for the game in Assignment 18.1 decide what
entities you intend to implement and normalise for your chosen database example. You
are expected to need five related entities.
Document the relationships, table structures, fields and properties.
Check with your tutor and get this signed off before proceeding to the next task. Modify
as necessary and implement your design.
Task 2
Using the information provided, design and implement suitable data entry forms for the
capturing of the information incorporating features to ensure the validity and integrity of
data.
You must include at least three of the following techniques within the set of data entry
forms:
o Validation routine
o Verification routine
o Input masking
o Check for completeness
o Visual prompts
o Data consistency
o Check for data redundancy
, Drop-down/combo boxes. P3, P4
Enter sufficient data into the system. At least some of the data should be imported
from an external source that will be provided for you. M2
Task 3-P5
Devise at least 3 queries that respond to the requirements identified using multiple tables and
multiple criteria.
Sources of information: Blackboard (BTEC IT Level 3/Course Materials), Teacher hand-outs,
BTEC National Information Technology Level 3 Course Manual, Internet Resources, YouTube Videos.
Learner & Assessor feedback and declaration
Gradin Achieved?
Assessor Feedback
g Yes/No
criteri
P2
P3
P4
P5
M2
Learner feedback
Learner declaration
I certify that the work submitted for this assignment is my own and research sources are fully
acknowledged
OR by submitting on Turnitin you agree to the above statement.
Learner signature: Date:
Assessor declaration
I certify that the evidence submitted for this assignment is the learner’s own. The learner has
clearly referenced any sources used in the work. I understand that false declaration is a form of
malpractice OR where the assignment is being submitted on Turnitin you agree to the above
statement.
Assessor signature: Date:
This brief has been verified as being fit for purpose
Assessor
Signature MJK Date 26/08/2020
Internal
Verifier
Signature Naz Gul Date 26/08/2020
, To import data, first click on external data then new data source and
click on excel.
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 hasanqadri12003. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £7.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
67474 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now