C170 Revised

Create Database Syntax Correct Answer CREATE DATABASE db_name; Simple SFW query syntax Correct Answer SELECT * FROM db_name WHERE column_name operator value; Cardinality: Inside or outside? Correct Answer Outside Modality: Inside or outside? Correct Answer Inside What commands are used with data definition? Correct Answer create, alter, drop, truncate, comment, rename What commands are used with data manipulation? Correct Answer Select, Insert, Update, Delete, Merge, Call, Explain...

Western Governors University - C170 Course Study Glossary of all Chapter Terms 1.AREA: In DB2, a named sectionof permanent storage space that is reserved to store the database. iative entity: See composite entity. e entity: See composite entity. date key: A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey. See key. re: A property of relational operators that permits the use of relational algebra operators on existing tables (relatio...

I gleaned this table from the unstructured data contained within the order form. I made sure not to have any redundant groups, and each column in the table will contain atomic values. Donut ID, Donut Name, Donut Quantity, Unit Price, and Donut Description are an example of a repeating group. As I mentioned earlier, in order to achieve first normal form, we must eliminate repeating groups. This requires the use of a composite key made up of Donut Order ID and Donut ID.