Terms for Database Systems Crossword Puzzle

QUESTIONS LIST:

• flat files:a collection of data stored in a two-dimensional database in which similar yet discrete strings of information are stored as records in a table.
• data type:an attribute associated with a piece of data that tells a computer system how to interpret its value.
• referential integrity:a property of data stating that all its references are valid.
• foreign key:a column or group of columns in a relational database table that provides a link between data in two tables.
• primary key:the column or columns that contain values that uniquely identify each row in a table
• rows: a single group of related data within a table which goes horizontally on a table
• entity integrity:ensures that each row of a table has a unique and non-null primary key value.
• relational model:an approach to manage data using a structure
• secondary key:an additional key, which can be used in addition to the primary key to locate specific data
• domain integrity:a series of processes that guarantee the accuracy of pieces of data within a domain
• sql: a programming language for storing and processing information in a relational database.
• database: an organised collection of structured information, or data, typically stored electronically in a computer system
• column: a list of values, usually belonging to a particular field, displayed vertically in a table
• table: a database object that contains all the data in a database, data is logically organised in a row and column format which may be similar to a spreadsheet.
• index:a list of items such as a topic or name treated in a printed work that gives for each item the page number where it may be found