DPR 100 Chapter 11 Crossword

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
Across
  1. 3. warehouse A large-scale collection of data that contains and organizes in one place all the data from an organization’s multiple databases.
  2. 4. report A report generated by a management information system that provides a consolidated picture of detailed data; these reports usually include some calculation or visual displays of information.
  3. 9. In a relational database, a link between tables that defines how the data is related.
  4. 11. The process of ensuring that data entered into a field of a database meets specified guidelines.
  5. 13. See unstructured data.
  6. 15. data Software used on company websites to capture information about each click that users make as they navigate through the site.
  7. 17. database A database that stores data in objects rather than in tables.
  8. 19. A system designed to improve communications and assist employees in accomplishing their daily tasks.
  9. 21. form Used to control how new data is entered into a shared database.
  10. 22. data Audio clips, video clips, pictures, and extremely large documents. Also called binary large object
  11. 24. In a database, temporarily displays records that match certain criteria.
  12. 25. processing The processing of database transactions in which the database is updated while the transaction is taking place.
  13. 26. A process to ensure data is organized most efficiently in a database.
  14. 30. system A business intelligence system that provides intelligence that supplements the user’s own intellect and makes the decision support system more effective.
  15. 31. check In a database, ensures that all required fields have been completed.
  16. 36. relationship In a relational database, records in one table are related to multiple records in a second table, and vice versa.
  17. 39. relationship In a relational database, for each record in a table there’s only one corresponding record in a related table.
  18. 41. The real-time processing of database transactions online.
  19. 42. check In a database, confirms that only textual characters are entered in a field.
  20. 43. administrator An information technology professional responsible for designing, constructing, and maintaining databases.
  21. 44. check In a database, confirms that only numbers are entered in a field.
  22. 45. check In a database, compares the values of data in two or more fields to see if those values are reasonable.
  23. 47. system A system that includes data, people, procedures, hardware, and software that help in planning and decision making; a software-based solution used to gather and analyze information.
  24. 48. A group of related records in a database.
  25. 50. key field In a database, a field that has a value unique to a record.
  26. 51. system A system that tries to replicate the decision-making processes of human experts in order to solve specific problems.
  27. 52. intelligence The branch of computer science that deals with the attempt to create computers that think like humans.
  28. 53. check Ensures that the data entered into the field of a database falls within a certain range of values.
  29. 54. report A report generated by a management information system that provides a list of the transactions that occurred during a certain time period.
  30. 55. A group of related fields in a database.
  31. 58. A type of business intelligence system designed to help managers develop solutions for specific problems.
Down
  1. 1. logic Enables the interjection of experiential learning into knowledge-based systems by allowing the consideration of probabilities.
  2. 2. inconsistency Data for a record being different in two different lists.
  3. 5. database A database that stores data from different perspectives, called dimensions, and organizes data in cube format.
  4. 6. A type of business intelligence system for keeping track of everyday business activities.
  5. 7. query A query used to extract data that’s in two or more tables in a database.
  6. 8. A database programming language used to construct queries to extract data from relational databases; one example of a fourth-generation language.
  7. 10. A query language used by many object-oriented databases.
  8. 12. name A way of describing the information in the field.
  9. 14. processing The accumulation of transaction data until a certain point is reached, at which time several transactions are processed at once.
  10. 16. A type of business intelligence system that provides timely and accurate information that enables managers to make critical business decisions.
  11. 18. intelligence systems Systems used to analyze and interpret data in order to enable managers to make informed decisions about how best to run a business.
  12. 20. query In Structured Query Language, displays a subset of data from a table based on the criteria specified.
  13. 23. integrity 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.
  14. 27. data Data that doesn’t pertain to one period in time.
  15. 28. language A specially designed computer language used to manipulate data in or extract data from a database.
  16. 29. value The value a database automatically uses for a field unless the user enters another value.
  17. 32. algebra The use of English-like expressions that have variables and operations, much like algebraic equations, to extract data from databases using Structured Query Language.
  18. 33. Data that describes other data.
  19. 34. management system Software that assists in building management models in decision support systems; an analysis tool that, through the use of internal and external data, provides a view of a particular business situation for the purposes of decision making.
  20. 35. data Data such as “Bill” or “345,” as opposed to unstructured data.
  21. 37. system A knowledge-based business intelligence system that enables users to communicate with computer systems using a natural spoken or written language instead of a computer programming language.
  22. 38. relationship In a relational database, a record appears only once in one table while having the capability of appearing many times in a related table.
  23. 39. Software that provides standardized tools for viewing and manipulating data in a data warehouse.
  24. 40. type Describes the kind of data being stored at the memory location; each programming language has its own data types
  25. 46. key In a relational database, the common field between tables that’s not the primary key.
  26. 49. report A report generated by a management information system that shows conditions that are unusual or that need attention by system users.
  27. 56. system A business intelligence system that accumulates in a central location all information relevant to running a business and makes it readily available to whoever needs it to make decisions.
  28. 57. A specially designed application software used to create and manage databases.