Wgu c170 chapter 1 - Study guides, Class notes & Summaries

AREA - In DB2, a named section of permanent storage space that is reserved to store the database. associative entity - See composite entity. bridge entity - See composite entity. candidate key - A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey. See key. closure - A property of relational operators that permits the use of relational algebra operators on existing tables (relations) to produce new relations. composite entity - An enti...

WGU c170 The Most Important SQL Commands(SQL study guide) Notes for C170 Some of The Most Important SQL Commands SELECT - extracts data from a database UPDATE - updates data in a database DELETE - deletes data from a database INSERT INTO - inserts new data into a database CREATE DATABASE - creates a new database ALTER DATABASE - modifies a database CREATE TABLE - creates a new table ALTER TABLE - modifies a table DROP TABLE - deletes a table CREATE INDEX - creates an index (search ke...

WGU C170 Chapter 1/52 Questions and Answers

WGU C170 Chapter 1 Verified Scores AREA Ans- In DB2, a named section of permanent storage space that is reserved to store the database. associative entity Ans- See composite entity. bridge entity Ans- See composite entity. candidate key Ans- A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey. See key. closure Ans- A property of relational operators that permits the use of relational algebra operators on existing tables (relations) t...

WGU C170 Chapter 1 question & answers 100% correctAREA In DB2, a named section of permanent storage space that is reserved to store the database. associative entity See composite entity. 00:07 01:41 bridge entity See composite entity. candidate key A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey. See key. closure A property of relational operators that permits the use of relational algebra operator...