CIS3465: Database Management
The University of Texas at
El Paso
Match the Following Terms on the Left with the Correct Definitions on the Right:
____ Candidate key ____ Composite key ____ Data Type ____ Determination ____ Entity ____ Entity Integrity ____ Fields ____ Foreign Key ____ Fully Relational ____ Functional Dependence ____ Join ____ Minimally
relational ____ Natural Joins ____ Primary Key ____ Record ____ Relational Integrity ____ Relationally Complete ____ RDBMS ____ RDBMS Convention ____ Secondary key ____ Select ____ Super Key ____ Table ____ Table Products ____ Tuple ____ 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 |
1. Given the statement: You are an entity with attributes that vary.
Within the University, different areas have different interests
in you (i.e., the Registrar, the Bursar, etc.). Nonetheless, you are still part
of the University as a whole. Explain how this relates to a RDBMS
in terms of structure.
2. We listed five (5) RDBMS conventions restrictions. One of them is
that the order of rows (records/Entries) is not important. List three (3) other
ones.
3. Explain the difference between a primary key, a composite key, a
super key, a candidate key, and a secondary key.
4. What is the purpose of using Keys in RDMS?
5. Explain what a foreign key is, how it is used, and illustrate at
least example of usage.
6. Explain what entity and relational integrity are, and what rules the RDMS maintains in enforcing them
7. List the three BASIC SQL operations which an RDMS supports, and explain what they do.
8. List and Explain at least three other SQL Operations which an RDBMS might support.
9. List and explain the four levels of RDBMS classifications.