Print| NO | Assessment statement | Link | Teacher’s notes |
| 1 | Differentiate between data and information. | Data is meaningless. To be useful,data must be interpreted to produce information. | |
| 2 | Outline the differences between an information system and a database. | Students must be aware that these terms are not synonymous. Databases are a component within an information system MYP Technology. |
|
| 3 | Discuss the need for databases. | This should address topics such as the benefits of data sharing. S/E For example, correct information relating to customers and/or clients. |
|
| 4 | Describe the use of transactions,states and updates to maintain data consistency (and integrity). | For example, to ensure data consistency when moving money between two accounts it is necessary to complete two operations (debiting one account and crediting the other). Unless both operations are carried out successfully, the transaction will be rolled back. S/E For example, ensuring correct information relating to customers and/or clients. |
|
| 5 | Define the term database transaction. | . | |
| 6 | Explain concurrency in a data sharing situation. | . | |
| 7 | Explain the importance of the ACID properties of a database transaction. | ACID refers to:
|
|
| 3 | Describe the two functions databases require to be performed on them. | Query functions and update functions. | |
| 5 | Explain the role of data validation and data verification. | . |