Summary
Summary unit 18
- Module
- Unit 18 - Database Design
- Institution
- PEARSON (PEARSON)
Summary of 9 pages for the course Unit 18 - Database Design at PEARSON (fvd)
[Show more]
Seller
Follow
Content preview
Assignment front sheetCriteria To achieve the criteria the evidence must show that
Task no. Evidence Page no
reference the student is able to:
P1 Explain the features of a relational database Task 1 Game
Explain referential integrity and the purpose of
M1 primary keys in building the relationships between Task 3 Presentation
tables
Learner name Assessor Name
Omit Ali Nas Akhter
Date issued Hand in deadline Submitted on
01/03/2021 05/03/2021
Resubmission (out) (if applicable) Resubmission (in) Lead IV authorisation
M J Khaliq
Qualification Unit number and title
Level 3 BTEC National Diploma in IT Unit 18 – Database Design
Assignment title 18.1 Features of a Database
In this assessment you will have opportunities to provide evidence against the following criteria. Indicate the page numbers where the evidence
can be found.
Learner feedback and declaration
Learner feedback
Learner declaration
By signing below, OR submitting to my named Turnitin account, I certify that the work submitted for this assignment is my own &
research sources are fully acknowledged.
Learner signature: Date:
, Primary keys A) A relational database makes it
simple to locate unique
information. It also lets you sort
by any field and create reports
that only include those fields of
each record. When determining
customer address information to
print out report labels,
documents could be produced.
Foreign keys B) When you use a relational
database, you can sort data with
a single click of a button. A
relational database organizes data
into different areas and allows
users to search for information by
field or by connecting fields
between similar records.
Referential integrity C) A relational database helps you to
run queries to find unique
information in your database.
Auto incremented keys D) A flat file database, like a
relational database, can hold a
large number of data. It will take
a long time to go through the data
in a flat file database to find what
you're searching for. A query in a
relational database helps you to
look for something unique in the
database.
Field attributes E) A flat file database stores data
that is repeated; this wastes
space and slows query time. A
relational database, unlike a flat
file database, uses normalization
to minimize data replication. Any
data that isn't important will be
removed from the database.
Data redundancy F) Data can be entered several times
in a flat file database, taking up
more space. If there is more than
one instance of similar data in a
relational database, reduced data
redundancy is used to reduce the
amount of data that needs to be
processed.
Data types G) A many-to-many relationship is a
database relationship in which a
Page 2 of 9
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