DP Computer Science Questionbank

Outline why data validation is difficult for the Book_Title attribute.

Outline how data consistency can be maintained in transactions in this database system.

Outline why atomicity is important within a database.

Explain how concurrent use of the school database is possible in this situation.

Define the term database transaction.

Explain the importance of durability in a database transaction.

With reference to the relation CLASS_TABLE distinguish between data and information.

Explain the role of data validation and data verification.

Explain how Total could be validated.

A bank maintains a database that stores details of clients and their accounts.

A client wants to transfer money between two accounts held at the same bank.

Explain how the ACID (Atomicity, Consistency, Isolation, Durability) properties would apply in the context of this database transaction.

Outline the difference between an information system and a database.

Outline why the transaction needs to be atomic in the context of this scenario.

Explain how transactions are managed to ensure isolation when registered teachers add comments to a discussion thread on the forum.

Outline, using an example, how data validation can ensure that data is entered into the birds database correctly.

Outline, using an example, how data verification can ensure that data is entered into the birds database correctly.

Distinguish between data and information when entering the length of a spoonbill’s beak in the database.

Explain why Date of birth has been separated into three fields.

Define the term database transaction.

Outline how the Billetmania information system would utilize a database.

Explain the importance of transaction durability to Billetmania when clients book tickets.

Identify two types of update anomaly.

Identify three ways that incorrect data could be prevented from being added into the School_phone_no field.