Database Concepts: Questionnaires & Answers (6-10)
Questionnaire 6: SQL and Relational Models
Clauses, Views, and Constraints
1. Clause for Evaluating SQL Tables:
FROM
2. Virtual Table Defined with an SQL Query:
View
3. Benefit of Views:
Logical Data Independence
4. Finding Tuple Fragments in Different Tables:
The Match Predicate
5. Adjusting Database Models for Specific Applications:
Restrictions
6. Limiting Values to Native Data Types:
Domain Restrictions
7. Specifying Primary/Foreign Keys and Applying Tests:
Table Constraints
8. Types of Column Constraints:
Primary Key, Reference, and Test Constraints
9. Specifying Global Restrictions with Assertions:
The Schema
10. Limited Handling of Non-Text Data Types:
Relational Model
Questionnaire 7: Object-Oriented Models
Objects, Messages, and Polymorphism
1. Plots Relations with Logical Objects and Recursion:
Object-Oriented Model
2. Message Transmitted from Object or UI:
Signal or Message
3. Definition of a Message Signature:
Sequence of Keywords Specifying the Generic Format to Invoke the Signal
4. Reading and Writing Attribute Values:
Attribute Signals
5. Procedure Invoked by an Object:
Method
6. Processing Messages Without Required Method:
Class
7. Using the Same Signature for Different Methods:
Polymorphism
8. Alternative Name for Polymorphism:
Delayed Binding
9. Database with Objects and Inclusion Logic:
Object-Oriented Database (OODB)
10. Passive Set of Data Elements in an Object-Oriented Database:
Relational Database
Questionnaire 8: SQL Queries and Data Retrieval
Conceptual Models, SELECT Statements, and Recursive Queries
1. Conceptual Schema from Descriptive Lists:
Conceptual Model
2. Basis of Queries:
SELECT Statement
3. Primary Language for Relational DBMS Manipulation:
Structured Query Language (SQL)
4. Clauses for Data Retrieval in SQL Extensions:
SELECT, FROM, WHERE
5. Instruction for Querying Specific Information:
SELECT
6. Specifying Row Display in a Table:
WHERE
7. Defining the Source Table for Data:
FROM
8. Determining Presentation Order:
ORDER BY
9. Simplifying Recursive Query Code:
Recursive Queries
10. Queries That Return No Records and Modify Data:
Update Queries
Questionnaire 9: Deductive Databases and Logical Programming
Predicates, Rules, and Deductive Reasoning
1. Boolean Function of Arguments:
Database Predicate
2. Specifying Values for Function Variables:
Assignment
3. Types of Database Predicates:
Literal (Arithmetical or Derivative)
4. Structure with Head and Body:
Rule Reference
5. Predicate Appearing as the Head of Inference Rules:
Derivative Predicate
6. Creating a World with Truth Values for Literals:
Designer
7. Set of True Literals from Database and Derivative Predicates:
Minimum Model
8. Variable in Rule Body but Not in Head:
Encyclopedic Variable
9. Set of Rules for Deducing New Facts:
Logical Program
10. Maintaining Data Elements and Relations as Axioms:
Deductive Database
Questionnaire 10: Deductive Queries and Relational Algebra
Query Types, Aggregate Functions, and Recursive Queries
1. Definition of a Deductive Query:
A database system capable of defining rules to deduce information from stored facts.
2. Three Categories of Queries:
Existential Search, Universal Search, and Aggregate
3. Queries Based on Attributes Without Proof:
Existential Search
4. Queries Using Negative Predicates:
Universal Search
5. Definition of an Aggregate:
Calculation on a set of values returning a single value.
6. Definition of Relational Algebra:
A set of operations describing how to process responses on relations.
7. Condition for Compatible Union:
Two relations with the same degree and matching domains from left to right.
8. Definition of a Recursive Query:
A query where the server application launches another query to determine the current search.
9. Specification Types in Deductive Databases:
Facts and Rules
10. Definition of a Declarative Language:
A language defining what a program aims to achieve.