Wjec Aslevel 1.7 Databases Computer Science
Presentation
•
Computers
•
11th Grade
•
Practice Problem
•
Easy
R Roy
Used 2+ times
FREE Resource
28 Slides • 24 Questions
1
2
3
4
5
Multiple Choice
Which of the following best describes a database?
A random collection of files
An organised collection of data
A single spreadsheet
A programming language
6
Open Ended
Why is it important for data to be organised in a database?
7
Multiple Choice
Which of the following is an advantage of using a database over a file system?
Databases are more expensive to maintain
Data duplication is avoided
Data is stored multiple times
Databases are less consistent
8
Open Ended
List two different applications of databases mentioned in the diagram and explain how databases are useful in those areas.
9
10
11
Fill in the Blanks
12
13
Multiple Select
Which of the following software can be used to create and manage databases?
Microsoft Access
Python
SQL
JavaScript
14
15
Open Ended
Explain the difference between a flat-file database and a table in a relational database.
16
17
Multiple Choice
Which of the following is a key difference between relational databases and flat-file databases?
Relational databases have redundant data, flat-file databases do not.
Relational databases are less efficient than flat-file databases.
Relational databases distribute data over various tables, flat-file databases store data in a single table.
Flat-file databases use relationships to connect data, relational databases do not.
18
Multiple Choice
Which of the following statements about primary keys is correct?
A primary key can be duplicated in different records
A primary key is always a combination of letters and numbers
A primary key uniquely identifies each record in a table
A primary key is optional in a database table
19
Open Ended
Discuss the advantages and disadvantages of using a relational database approach compared to a flat-file database.
20
21
22
Multiple Select
Which of the following are advantages of a relational database approach over a flat-file database?
Data does not need to be entered twice.
Validation of data is easier using a range of checks.
Different security access can be given to different parts of the data.
Flat files are easier to set up and maintain.
23
Fill in the Blanks
24
25
Open Ended
Explain the role of primary keys and foreign keys in a relational database.
26
27
Multiple Choice
In the entity description 'Book(BookID, Title, Author, Publisher)', which attribute is the primary key?
Title
Author
BookID
Publisher
28
29
30
31
Multiple Choice
What is the primary purpose of using MemberID and BookID in the Bookslent table?
To store additional information about books and members
To act as foreign keys referencing other tables
To calculate fines for overdue books
To display the names of authors and members
32
33
34
Open Ended
Explain how referential integrity is maintained between the Books and Bookslent tables. Why is it important?
35
36
Multiple Select
Which of the following relationships can exist between entities in a database?
One to one
One to many
Many to many
None of the above
37
38
39
40
Multiple Choice
Which of the following best describes a one-to-one relationship between entities?
A person has one email address
A library has many members
Many students can take a course
A course can have many students
41
Fill in the Blanks
42
Open Ended
Explain the difference between one-to-many and many-to-many relationships between entities, using examples from the slides.
43
44
Fill in the Blanks
45
Multiple Select
Which of the following are true about a relational database?
It stores data in tables
It allows users to identify and access related data
It consists of various records and fields
It is only used for storing images
46
47
48
49
50
51
Fill in the Blanks
52
Open Ended
Based on today's lesson, how would you explain what a database is to someone who has never heard of it before?
Show answer
Auto Play
Slide 1 / 52
SLIDE
Similar Resources on Wayground
52 questions
português - Termos da oração
Presentation
•
KG
45 questions
Clase de P. Periódicas
Presentation
•
11th Grade
47 questions
U8 L1 Development Life Cycle
Presentation
•
10th Grade
46 questions
GDPR en wetgeving
Presentation
•
KG
51 questions
EmTechWk2Lesson1.2
Presentation
•
11th - 12th Grade
49 questions
Oil mining and spills
Presentation
•
11th Grade
47 questions
Géneros periodísticos II
Presentation
•
11th Grade
52 questions
Endogenic Processes I
Presentation
•
11th Grade
Popular Resources on Wayground
24 questions
PBIS-HGMS Day 10
Quiz
•
6th - 8th Grade
10 questions
HCS SCI 03 Summer School Review 3
Quiz
•
3rd Grade
11 questions
Home Scope
Quiz
•
7th - 8th Grade
15 questions
HCS SCI 05 Summer School Assessment 3 Review
Quiz
•
5th Grade
35 questions
Lufkin Road Middle School Student Handbook & Policies Assessment
Quiz
•
7th Grade
18 questions
Geo 11.3 Area of Circles and Sectors
Quiz
•
9th - 11th Grade