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 is in second normal form and has no functional (transitive) dependencies between two (or more) nonprimary key attributes.


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)

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Essentials Of Systems Analysis And Design

ISBN: 9780133469530

5th Edition

Authors: Joseph Valacich, Joey F George

Question Posted: