Attribute whose values match primary key values in related table.
What is a Foreign Key ?
100
Provides detailed description of all tables found within the user/designer created database.
What is a Data Dictionary?
200
A key composed of one attribute (or a combination of attributes) that uniquely identify any given row.
What is a Primary Key ?
200
A key used strictly for data retrieval purposes ?
What is a Secondary Key?
200
An orderly arrangement used to logically access rows in a table.
What is an Index?
300
A key composed of more than one attribute
What is a Composite Key?
300
This ensures that each row will have a unique identity, and foreign key values can properly reference primary key values .
What is Entity Integrity ?
300
Defines the theoretical way of manipulating table contents using the eight relational operators: SELECT, PROJECT, JOIN, INTERSECT, UNION, DIFFERENCE, PRODUCT,and DIVIDE.
What is Relational Algebra?
400
This value is not permitted in a primary key. Also should be avoided in other attributes.
What is a Null Value ?
400
This ensures that an item's foreign key is either null or matches the primary key value in a table to which it is related.
What is Reference Integrity ?
400
Is a textual representation of the database tables where each table is listed by it name followed by the list of its attributes in parentheses.
What is a Relational Schema ?
500
A superkey without unnecessary attributes
What is a Candidate Key ?
500
Specific range of values each column has.
What is the attribute domain ?
500
A detailed system data dictionary that describes all objects within the database, including data about table names, the table's creator and creation date, the number of columns in each table, etc....