Database Lesson 2 Key Terms

123456789101112
Across
  1. 3. The way to gather information from these tales is to create a many-to-many relationship between two tables’ relationships with a third table.
  2. 5. Each record in Table A can have only one matching record in Table B, and vice versa. The relationship is created only if both of the related fields are primary keys.
  3. 6. is the most common type of relationship in a database. A record in Table A can have multiple records in Table B, but a record in Table B has only one matching record in Table A. The relationship is created only if the related field is the primary key in Table A and a foreign key in Table B
  4. 10. is created within each new table
  5. 11. One record in Table A can relate to many matching records in Table B, and vice versa.
  6. 12. information stored in a table can be defined by its length and how it is formatted
Down
  1. 1. provides a simplified interface for adding, modifying and viewing the database records.
  2. 2. is a group of fields in a table related to a single entity and is contained in a row within that table
  3. 4. a field that refers back to a primary key in a table
  4. 7. is the resulting data of a query and is a way to display data in a visually appealing and easy to read format.
  5. 8. variables organized as columns in a table
  6. 9. uniquely identify each record in a table and help to link related records
  7. 12. looks similar to a spreadsheet in that it displays the table you are working on within a column and row fashion.