| UNION | | THE INTEGRITY THAT DOESN'T ALLOW AN ATTRIBUTRE OF A PRIMARY KEY TO BE NULL |
| UPDATE | | A RELATIONAL ALGEBRA OPERATION WHERE ALL TUPLES THAT ARE COMMON IN BOTH RELATIONS |
| COUNT | | AGGREGATE FUNCTION TO FIND THE TOTAL NUMBER OF VALUES OF AN ATTRIBUTE |
| DISTINCT | | A SUPERKEY WITH NO PROPER SUBSET |
| DELETEFROM | | USED TO ENTER A NEW TUPLE IN A TABLE(SQL) |
| ISNULL | | A VALUE THAT IS UNKNOWN OR NOT APPLICABLE |
| ORDERBY | | THE LANGUAGE TO CHANGE/MANIPULATE THE DATA |
| HAVING | | A DERIVED RELATION |
| SYBQUERY | | USED FOR SORTING RESULTS (SQL) |
| ENTERPRISE | | NOTE THE FOLLOWING EXPRESSION (SELECT A, SUM(B) FROM TABLE1), WHICH CLAUSE MUST WE USE |
| VIEW | | IT ELIMINATES DUPLICATES |
| DATABASE | | USED TO FIND WHETHER A VALUE IS NULL |
| SUPERKEY | | ATTRIBUTES THAT UNIQUELY IDENTIFY TUPLE IN A RELATION |
| DDL | | USED IN A MEMBERSHIP SEARCH CONDITION(SQL) |
| INSERTINTO | | NUMBER OF TUPLES |
| DML | | USED IN PATTERN MATCH SEARCH CONDITION(SQL) |
| CARDINALITY | | IT RESTRICTS THE VALUES IN ROWS(SQL) |
| DIFFERENCE | | THE LANGUAGE TO DESCRIBE THE DATA |
| NULL | | A RELATIONAL ALGEBRA OPERATION WHERE TUPLES THAT ARE IN RELATION R BUT NOT IN RELATION S |
| WHERE | | NUMBER OF ATTRIBUTES |
| ENTITY | | A COLLECTION OF LOGICALLY RELATED DATA |
| SEMIJOIN | | USED TO CHANGE THE VALUE IN AN ATTRIBUTE (SQL) |
| ALTERNATE | | NOT SELECTED AS A PRIMARY KEY |
| BETWEENAND | | USED TO ERASE DATA (SQL) |
| IN | | A RELATIONAL ALGEBRA OPERATION WHERE ALL TUPLES FROM BOTH RELATIONS DUPLICATES ELIMINATED |
| GROUPBY | | USED INSTEAD OF A JOIN |
| CANDIDATEKEY | | A RELATIONAL ALGEBRA OPERATION WHERE IT CONTAINS THE TUPLES OF R THAT PARTICIPATE IN THE JOIN OF R WITH S |
| DEGREE | | ADDITIONAL RULES SPECIFIED BY THE USER |
| INTERSECTION | | IT RESTRICTS THE VALUES OF GROUPS (SQL) |
| LIKE | | USED IN A RANGE SEARCH CONDITION (SQL) |