Database Design

2. the noun of a database (person, place, thing, or event)
3. a field in one table whose values are required to match the primary key of another table
6. a field that is not a part of the primary key
11. a table in second normal form and the only determinants are candidate keys
13. a field's value that is determined from another value is said to be this
14. a table in first normal form and no nonkey field is dependent on only a portion of the primary key
15. a table that contains a repeating group
16. to combine a field name with a table name
20. a collection of relations
23. process of determining the particular tables and fields that will comprise a database
24. being able to figure out the value of a field from knowing the value of another field
25. the field or fields that uniquely identifies a given row in that table

1. any field or fields that determines another field
4. a process to make sure the database is free of potential update, redundancy, and consistency problems
5. multiple entries for a position in a database
7. a database diagram that represents the tables with rectangles and the primary key is listed above a line
8. two-dimensional table
9. columns in a table
10. problems that are either update, inconsistent data, additions, or deletions
12. property of an entity
17. a table that does not contain repeating groups is in this form
18. a field or fields on which all fields in the table are functionally dependent
19. tables are converted into these after the normalization process
21. an association between entities
22. rows in a table