Level 130 Level 132
Level 131

Databases & Information Systems

16 words 0 ignored

Ready to learn       Ready to review

Ignore words

Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.

All None

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.
relational database
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.
Data type
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.
Telephone Book
Example of Analog Flat File Database