Describe what is meant by a database

A persistent and organised store of data

studbud

Edxcel 3.5 - Database Basics - GCSE Computer Science

13 termsStudBud Administration7 plays

GCSE Computer Science: Databases #Edexcel #9-1 #gcsecomputerscience #databases

Flashcards13 cardsFPractice quizPHost liveL

Questions 13

Answers

1
Two or more tables linked together by common attributes is called a
Relational Database
Primary Key
Flat-file Database
Spreadsheet
2
Text, Integer, Decimal, Boolean are all examples of which of these?
Records
Fields
Validations
Data Types
3
A primary key that is a combination of two or more attributes is a.... [HARD A* QUESTION!]
Non-Key
Composite Key
Primary Key 2
Foreign Key
4
Describe what is meant by a database
The @ sign in an e-mail address
A persistent and organised store of data
Files on a computer like .txt
A table where you can hold data
5
Which one is NOT a database?
A single shopping List
Contacts List
Recipes List
Your collection of videos (DVD etc) List
6
What TYPE of software enables the creation and management of data bases?
Data making software
Data minting software
Data handling software
Data helping software
7
How do you ensure data stolen by hackers can't be read easily?
Organise it
Encrypt it
Delete it
Back it up
8
What does DBMS stand for?
Data Base Minor Strategy
Data Base Management System
Data Binding Meeting System
Data Blending Management Service
9
In the below example, what is the Primary Key?
ClassCode
PupilNumber
FirstName
Surname
10
A database with all the data in one table is called a....
Flat-file database
Simple database
Relational database
Single-table database
11
Why do you need a Primary Key in a database?
Because it won't work otherwise
Because it's the first field
As a unique identifier
12
Relational databases help to reduce ...
Two Table Corruption
Data duplication
Data complexity
Backup Failure
13
What is a foreign key?
Primary Key in another Table
All the Columns of the Table
An Uploaded File in a Database
New Data Added to Database

Edxcel 3.5 - Database Basics - GCSE Computer Science Flashcards | StudBud