Wjec Aslevel 1.7 Databases Computer Science

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

Open Ended

Why is it important for data to be organised in a database?

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

Open Ended

List two different applications of databases mentioned in the diagram and explain how databases are useful in those areas.

Multiple Select

Which of the following software can be used to create and manage databases?

• Microsoft Access

• Python

• SQL

• JavaScript

Open Ended

Explain the difference between a flat-file database and a table in a relational database.

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.

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

Open Ended

Discuss the advantages and disadvantages of using a relational database approach compared to a flat-file database.

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.

Open Ended

Explain the role of primary keys and foreign keys in a relational database.

Multiple Choice

In the entity description 'Book(BookID, Title, Author, Publisher)', which attribute is the primary key?

• Title

• Author

• BookID

• Publisher

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

Open Ended

Explain how referential integrity is maintained between the Books and Bookslent tables. Why is it important?

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

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

Open Ended

Explain the difference between one-to-many and many-to-many relationships between entities, using examples from the slides.

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

Open Ended

Based on today's lesson, how would you explain what a database is to someone who has never heard of it before?