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) |