CMSY 110 Chapter 11 Terms

1234567891011121314151617181920212223242526272829303132
Across
  1. 3. A type of database that is often represented as a list or simple table.
  2. 8. Data for a record being different in two different lists
  3. 12. In a database, generally defined as part of the data dictionary and specified in the field properties for each field
  4. 13. In Structured Query Language, displays a subset of data from a table (or tables) based on the criteria specified
  5. 14. Duplicated data in a list
  6. 15. The component of a database in which the database stores each category of information
  7. 17. A way of describing the information in the field
  8. 22. In a relational database, a condition where, for each value in the foreign key table, there’s a corresponding value in the primary key table
  9. 26. A database type that organizes data into related tables based on logical grouping
  10. 28. An information technology professional responsible for designing, constructing, and maintaining databases
  11. 29. In a relational database, a link between tables that defines how the data is related
  12. 30. In a relational database, a record appears only once in one table while having the capability of appearing many times in a related table
  13. 31. Used to control how new data is entered into a shared database
  14. 32. Used to control how new data is entered into a shared database
Down
  1. 1. Describes the kind of data being stored at the memory location
  2. 2. compares the values of data in two or more fields to see if those values are reasonable
  3. 4. In a database, temporarily displays records that match certain criteria
  4. 5. A process to ensure data is organized most efficiently in a database
  5. 6. Defines the maximum number of characters that a field can hold in a database
  6. 7. In a relational database, the common field between tables that’s not the primary key
  7. 9. A digital collection of related data that can be stored, sorted, organized, and queried
  8. 10. In a database, a field that has a value unique to a record
  9. 11. In an Access database table, the field name, data type, and other data elements
  10. 16. When data is maintained in only one file
  11. 18. The process of ensuring that data entered into a field of a database meets specified guidelines
  12. 19. A property in a database that enables the field name to display in a more meaningful or readable manner
  13. 20. The value a database automatically uses for a field unless the user enters another value
  14. 21. When the data in a database is accurate and reliable
  15. 23. A specially designed computer language used to manipulate data in or extract data from a database
  16. 24. A group of related fields in a database
  17. 25. a way of retrieving information that defines a particular subset of data; can be used to extract data from one or more tables
  18. 27. process by which great amounts of data are analyzed and investigated