Introduction to Databases
Across
- 3. software designed to store, retrieve, define, and manage data in a database
- 10. allow multiple users to access data at the same time
- 11. a phase of database deisgn that involves building a database sketch from requirements gathering and customer information. This sketch will consist of a data model with high-level entities and the relationships between them.
- 12. an object in a database that is logically organized in a row-and-column format and contains data about a subject.
- 13. the query language used by relational databases
- 15. a request for data from a database
- 17. a property of an entity that becomes a field in the physical database
- 18. a phase of database design that is multifaceted and complex and is centered around surviving without changing the meaning of the code.
- 19. occurs when the same piece of data is held in two separat locations
- 20. a phase of database design that is an implementation-nonspecific refinement of the work done in the conceptual phase, transforming the concepts into a full-fledged database requirement that will be the foundation for the implementation design
- 21. a column in a table that contains a set of data values of the same data type
Down
- 1. a phase of database design in which you adapt the logical model for implementation to the host RDBMS
- 2. part of conceptual design that becomes a table in the physical database and contains data about an object (NOUN)
- 4. describes the data in the database such as where and when it was collected
- 5. a primary key from another table that establishes the relationship between the two tables
- 6. a means of group objects in a database with a common theme
- 7. a field or fields in a table that uniquely identify a row, record, or tuple
- 8. a collection of facts or data
- 9. rules enforced on data columns of a table that are used to limit the type of data that can go into the table and ensure the accuracy and reliability of the data.
- 14. a candidate key selected to identify records in a table
- 16. an association between two tables or entities based on a primary key from one table and a foreign key in the second
- 22. a person who manages, maintains, and secures data in one or more data systems so that a user can perform analysis for business operations