Across
- 2. A function that allows users to "ask the database a question" in order to find certain information in a database
- 3. A single set of information in a database
- 7. A database integrity concept that states the foreign key of a table has two states 1)the primary key of another table or 2)null
- 8. The relationship type that states each record in both tables can relate to any number of records (or no records) in the other table
- 9. A way to sort the database by bringing up specific records that match a term
- 11. The relationship type that states that the only one record in table related to none,one, or may records in another table
- 12. A way to sort the database by changing which records are displayed on screen
- 15. A way to sort the database by changing the order in which records are displayed
Down
- 1. The key that is a unique identifier for the information in a table
- 4. The relationship type that states that each primary key values related to only one (or no)records in the related table
- 5. A collection of organized data
- 6. The database model that uses rows, columns, and tables to organize the information in a database
- 10. The key that identifies the relationship between tables
- 12. The pieces of information in a record
- 13. The data integrity concept that states that each table must have a primary key that unique and not null
- 14. The data integrity concept that states all entries in a column are of the same type or constrained to a certain format