Match each of the key terms with the definition that best fits it. _____________ A relation that
Question:
Match each of the key terms with the definition that best fits it.
_____________ A relation that contains a minimum amount of redundancy and allows users to insert, modify, and delete the rows without errors or inconsistencies.
Here are the key terms from the chapter. The page where each term is first explained is in parentheses after the term.
1. Calculated (or computed or derived) field
2. Data type
3. Default value
4. Denormalization
5. Field
6. File organization
7. Foreign key
8. Functional dependency
9. Hashed file organization
10. Homonym
11. Index
12. Indexed file organization
13. Input mask
14. Normalization
15. Null value
16. Physical file
17. Physical table
18. Pointer
19. Primary key
20. Recursive foreign key
21. Referential integrity
22. Relation
23. Relational database model
24. Second normal form (2NF)
25. Secondary key
26. Sequential file organization
27. Synonyms
28. Third normal form (3NF)
29. Well-structured relation (or table)
Step by Step Answer:
Essentials Of Systems Analysis And Design
ISBN: 9780133469530
5th Edition
Authors: Joseph Valacich, Joey F George