TESTING, TESTING PLEASE:

Errors occur because commands aren't entered correctly

Syntax errors are where the code is not typed correctly

Logical errors are when the syntax is correct but the logic is wrong

Database

Key Terms:

Entity: Something that we store data about in a database
Record: All the data about one item in a database
Attribute: A characteristic of an entity. It becomes a field in a data table
Field: A characteristic of something stored in a database
Indexed sequential file: A sequential file that is accessed using an index, which is a separate file
Flat file database: Database consisting of only one table
Serial file: A file of items one after another
Sequential file: A serial file in order
Schema: Definition of a database
Data dictionary: the stored schema of a databse
DBMS: Data base management system


Definition:

A structured set of data held in a computer, especially one that is accessible in various ways.


What's a database for?

A database is for arranging large amounts of data in an organised fashion.