Lecture notes
1.7 Database Systems
- Institution
- WJEC
Full notes for module 1.7 Database Systems
[Show more]
Connected book
Book Title:
Author(s):
- Edition:
- ISBN:
- Edition:
Seller
FollowContent preview
AS ComputingUnit 1.7 Database Systems
There are two types of database, Flat-File and Relational. A flat file database is made up of just one
table while a relational database is made of one or more tables linked together. Each record in a
database should have a primary key. A primary key is used to uniquely identify a field, and it must
always be unique.
Repeated data in a database is a big problem because it wastes valuable space, this is also known as
data redundancy.
Advantages of Flat File Databases Disadvantages of Flat File Databases
Easy to understand Less security so it’s easy to extract data
Easy to implement Data inconsistency
Less hardware and software requirements Data redundancy
Less skills are required to create one Slow for huge databases
Best for small databases Searching process is very time consuming
The word relative means ‘considered in comparison or relation to something else – Interlinked’.
Therefore a relational database is two or more files linked together.
Key Components
1. Key Field
a. Uniquely identifies a record
b. No two records have the same data in the key field
c. Also called a primary key
2. Foreign Key
a. A field that appears in a table, that is the primary key of another table and forms a
link between the two tables
Links and Relationships
1. There are a few types of relationships in regards to databases, they are:
a. One-To-One
i. Products and Barcodes at a supermarket
b. One-To-Many
i. A video club member may rent more than one video
c. Many-To-Many
i. Pupils and Teachers in a school
These are represented as so:
Relationship Symbol
One-To-One
One-To-Many
Many-To-Many
Page |1 Luca Passariello AS Computing
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 luca_pass. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £5.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
53022 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