Across
- 3. is a data structure that consists of a group of database records, and can either come from a base table or as the result of a query to the table.
- 7. is one record (one row).The information in a database can be thought of as a spreadsheet, with columns (known as fields or attributes) representing different categories of information.
- 9. a type of cardinality that refers to the relationship between two entities[1] A and B in which A may contain a parent instance for which there are many children in B and vice versa.
- 11. is a constraint between two sets of attributes in a relation from a database. In other words, functional dependency is a constraint that describes the relationship between attributes in a relation.
- 12. is established between two database tables when one table has a foreign key that references the primary key of another table.
- 13. is a collection of related data held in a table format within a database. It consists of columns, and rows.
- 14. is a type of cardinality that refers to the relationship between two entities (see also entity–relationship model) A and B in which an element of A may be linked to many elements of B, but a member of B is linked to only one element of A. For instance, think of A as books, and B as pages. A book can have many pages, but a page can only be in one book.
- 15. is a special relational database table column (or combination of columns) designated to uniquely identify all table records.
Down
- 1. is the number of attributes in its header, or, in other words, the number of columns.
- 2. is a request for data or information from a database table or combination of tables. This data may be generated as results returned by Structured Query Language (SQL) or as pictorials, graphs or complex results,e.g.,trend analyses from data-mining tools.
- 4. relationship between two tables means that a row in one table can only relate to one row in the table on the other side of their relationship and vice versa. This is the least common database relationship
- 5. is a collection of processes that facilitate the designing, development, implementation and maintenance of enterprise data management systems
- 6. refers to all the values which a data element may contain. The rule for determining the domain boundary may be as simple as a data type with an enumerated list of values.
- 8. is a computer program, or a set of computer programs, that provide basic database management functionalities including creation and maintenance of databases.
- 10. is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data.