C170 Performance Assessment QUESTION AND ANSWER

Syntax for updating a specific column in a specific row - UPDATE table SET atrribute = value WHERE primary key = value; Syntax for deleting a row - DELETE FROM TableName WHERE PrimaryKey = #; Syntax for creating a view - CREATE VIEW name AS SELECT columnname CONCAT (attribute, ' ', attribute) AS newname, attributes FROM tablename Syntax to create an Index - CREATE INDEX indexname ON table (attribute); Syntax for inserting rows into a table - INSERT INTO TableName (ColumnName1, ColumnName2, ColumnName3) VALUES (Column1Value, Column2Value); Syntax for updating a value in a specific row - UPDATE TableName SET Attribute = NewValue WHERE PrimaryKey = #; Syntax for deleting a row from table - DELETE FROM TableName WHERE PrimaryKey = #; Going from Unnormalized to 1NF - Add a primary key