Level 130 Level 132
16 words 0 ignored
Ready to learn Ready to review
Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.
Process that sorts the way data is ordered and represented.
Flat file database
Database that contains one table. Simplest form of database, used by most analog systems.
A database that stores data in tables that consist of rows and columns.
A way of presenting information so that the order in which it is read is decided by the reader.
Any medium that links non-sequentially to other media.
Horizontal row in table, representing a data item. Also called tuple.
Horizontal row in table, describes a data item, also called record.
A characteristic of an entity or object. An attribute has a name and a data type.
A column in a table.
Spreadsheet v Database
Sorts are done on individual columns in spreadsheets, each cell is manipulated individually. Databases manipulate records, which are described by a set of attributes.
Describes type of attribute. Data types are decided by the software or DBMS.
List common Data Types
Decisions for Numeric v Text data type
Does the data require mathematical manipulations? If so, number is suitable.
Considerations for Text data type
Does it have a maximum character length? The smallest data type should be chosen
Considerations for Number data type
Range - signed or unsigned numbers, integer or long integer.
Example of Analog Flat File Database