Write definitions using your own words for the first 20 Key Terms on page 64 at

Question

Write definitions using your own words for the first 20 Key Terms on page 64 at the end of Chapter 2. Don't just copy and paste the definition from the book!

Title: Concepts of Database Management, 8th Edition            

Authors: Philip J. Pratt and Mary Z. Last

ISBN-10: 1285427106

ISBN-13: 9781285427102

Key Terms:

Aggregate Function:

AND Criterion:

Attribute:

Calculated Field:

Cartesian Product:

Comparison Operator:

Compound Condition:

Compound Criteria:

Computed Field:

Concatenation:

Criteria:

Criterion:

Delete Query:

Design Grid:

Difference:

Division:

Field:

Function:

Grouping INTERSECT Intersection:

Join:

Explanation / Answer

Please find the solution below :

Key Terms:

Aggregate Function: the functions which works on a group of data and results in one output for that group of data. Aggregate Function include count, max, min, sum, avg.

AND Criterion: In SQL, when we want to have two or more logically dependent conditions in a query, we used AND clause between the conditions which results true when all the conditions sperated by AND clause are true and false otherwise.

Attribute: In Database, columns are known as attributes ie the property of entities(i.e. tables). Each record(rows) is comprised of attributes.

Calculated Field: Attribute which obtains values based on some calculations based on the values of some other fields.

Cartesian Product: When 2 or more tables are joined without condition, each row of left table is combined with each row of right table.

For eg : if left table has n rows and right table has m rows then cartesian product will result in n*m rows.

Comparison Operator: Relational operators like =, !=, <>, >, <, >=, <= are known as comparision operators which compares the left hand operand with right hand operand based on th operator given.

Compound Condition : when two or more comparision operators are joined with logical operator (and, or) it becomes a compound condition

Compound Criteria : compound criteria is same as compound condition where two or more comparision operators are joined with logical operator (and, or).

Computed Field: Those fields which obtain their value as a result of some calculation based on the existing fields are known as Computed fields.

Concatenation: When values of two or more fields are combined and displayed as a single field, the operator to do so is known as concatenation.

Criteria: Criteria are one or moe conditions that a query must satisfy in order to return results.

Criterion: When there is only one condition, it is known as criterion.

Delete Query: Query used to delete records from a table based on some conditions.

Design Grid: It is the row column organization of data returned from SQL queries.

Difference: In relational algebra when we perform A - B, ie content of table A - content of table B, is knows as difference.

Division: Dividing a larger table into smaller parts is known as division

Field: field is a representation of column in a relational database.

Function: breaking a bigger code into smaller programs and calling these sub programs as and when required. these sub programs are known as functions.

Grouping : while performing calculations on aggregate functions we need to group the data based on some field so that some calculations can be performed on the group as one.

INTERSECT : if there is any common data for 2 or more relational database, we say that these tables intersect each other.

Intersection: the common data of two or more relational database is known as intersection

Join: combining data from 2 or more tables based on some conditions is known as join.

Please let me know if u face any difficulty in understanding.

Please vote up if satisfied.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.