Data Management - Foundations - D426 Wgu Study Guide Graded A+

database model {Ans: Describes the relationship between the data elements and provides a framework for organizing the data. contains 3 parts data structures operations rules}Normal forms {Ans: rules for designing tables with less redundancy.}CREATE TABLE {Ans: A SQL command that creates a table's structures using the characteristics and attributes given. CREATE TABLE Persons ( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) );}correlated {Ans: A subquery is ________ when the subquery's WHERE clause references a column from the outer query.}Inner join {Ans: Selects only matching left and right table rows.}Product {Ans: lists all combinations of rows of two tables.}