Match the Following Terms on the Left with the Correct Definitions on the Right:
18. Candidate key 07. Composite key 09. Data Type 14. Determination 26. Entity 23. Entity Integrity 06. Fields 25. Foreign Key 11. Fully Relational 21. Functional Dependence 02. Join 04. Minimally
relational 15. Natural Joins 24. Primary Key 22. Record 16. Relational Integrity 19. Relationally Complete 12. RDBMS 08. RDBMS Convention 01. Secondary key 05. Select 17. Super Key 03. Table 20. Table Products 13. Tuple 10. Union |
01. 02. 03. 04. 05. 06. 07. 08. 09. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. |
A key which can not uniquely determine other
values Merging values from tables based on a common
attribute A two dimensional array of data Supports Select, Product, and
Join operations only Extraction of values from a table A named column A concatentation of keys to form a unique
identifier An example is that all field names must be unique The manner is which specific data is stored Combines
the results of two unrelated queries into a single output Supports
all algebraic operations as well as entity and referential integrity A DBMS Approach that manages data as a collection
of tables A column in a relational table Knowing the value of one key means you know the
others Only common values from related tables are
included An example is that a foreign key must have a valid
entry in the referring table Either a composite key of primary key A key or combination of keys that may become a unique
identifier Supports
all algebraic operations but not entity and referential integrity The union of all possible combinations of table
elements When every nonkey is dependent upon a unique
identifier An entity instance An example is that primary keys can not be null A unique record identifier A key which is used to relate tables together Anything about which we wish to keep information |