Across
- 4. A field that corresponds to the primary key field in another table.
- 5. A single attribute of each record in a table.
- 6. A graphical interface that allows users to query a database by filling in information on the form.
- 7. A structured set of data held in a computer, usually in a way that is accessible by multiple concurrent users.
- 8. A field in a table that uniquely identifies a record.
- 12. A way to help programmers and other related parties make sense of database information.
- 14. The general structure of a database is called a schema. The schema defines the logical groupings and relationships between database objects such as tables and fields.
- 16. Proprietary relational database management system developed by Microsoft that was released in 1989. supports transaction processing, business intelligence, disaster recovery, and analytics applications.
- 17. The SQL command that allows you to set the max records returned by a query
- 18. A single instance of an entity stored in a database table.
- 19. A database that holds data on multiple related tables.
- 21. The SQL command that lets you narrow down your query to only the results you want.
- 25. A design technique that organizes data in a database in an optimal way. This results in it being easier to add, remove, and update data without introducing errors.
- 26. A property or characteristic of an entity
- 28. A real-world element that's being used in a business
- 29. A computer language that makes relational databases work.
- 32. The simplest kind of relationship. Two entities or attributes share a unique connection with each other
Down
- 1. A method of accessing a database using custom computer programs.
- 2. A method of accessing a database using forms that allow users to interact with the database.
- 3. Data that is produced by an organization's everyday operations. It's gathered in real time to provide a snapshot of what's happening in the present.
- 7. Software that allows users to define, manipulate, retrieve, and manage data stored in a database. Examples are Microsoft SQL Server, Oracle Database, MySQL, and Microsoft Access.
- 9. This kind of relationship exists when only one side of the relationship is unique.
- 10. All SQL statements must end with this
- 11. A method of accessing a database directly using the database management system itself.
- 13. A method of asking questions about the data stored in a database.
- 15. An association or dependency between two entities
- 20. An easy-to-read listing of the results of a query.
- 22. Historical data that is used to help people make decisions in the present. It's various categories include market data, transactional data, sensor data, natural language, and machine data.
- 23. DBMS developed by Microsoft and release in 1992. A viable solution for small environments with a few users
- 24. A data structure in a relational database that is comprised of fields (columns) and records (rows).
- 27. The SQL command that lets you view the specific information you want from the database.
- 30. A method of accessing a database using a graphical user interface that allows users to select what actions they want to perform on a database.
- 31. Open-source DBMS distributed by Oracle since 1995. Great solution for managing data from a small to medium website