Wgu C170 - Data Management - Applications Study Guide Rated A+

Surrogate key {Ans: An artificial PK introduced by the designer with the purpose of simplifying the assignment of primary keys to tables. They are usually numeric, they are often generated automatically by the DBMS, they are free of semantic content (they have no special meaning), and they are usually hidden from the end users.}Strong entity {Ans: An entity that is existence-independent, that is, it can exist apart from all of its related entities. Also called a regular entity.}Synonym {Ans: The use of different names to identify the same object, such as an entity, an attribute, or a relationship; For example, car and auto refer to the same object}DIFFERENCE {Ans: An operator used to yield all rows from one table that are not found in another union-compatible table. supplier - vendor}MAX {Ans: A SQL aggregate function that yields the maximum attribute value in a given column.}ROLLBACK {Ans: A SQL command that restores the database table contents to the condition that existed after the last COMMIT statement.}