C170 Performance Assessment Complete 2023

C170 Performance Assessment Complete 2023 Syntax for updating a specific column in a specific row Ans- UPDATE table SET atrribute = value WHERE primary key = value; Syntax for deleting a row Ans- DELETE FROM TableName WHERE PrimaryKey = #; Syntax for creating a view Ans- CREATE VIEW name AS SELECT columnname CONCAT (attribute, ' ', attribute) AS newname, attributes FROM tablename Syntax to create an Index Ans- CREATE INDEX indexname ON table (attribute); Syntax for inserting rows into a table Ans- INSERT INTO TableName (ColumnName1, ColumnName2, ColumnName3) VALUES (Column1Value, Column2Value); Syntax for updating a value in a specific row Ans- UPDATE TableName SET Attribute = NewValue WHERE PrimaryKey = #; Syntax for deleting a row from table Ans- DELETE FROM TableName WHERE PrimaryKey = #; Going from Unnormalized to 1NF Ans- Add a primary key Eliminate Redundancies Going from 1NF to 2NF Ans- Create separate tables Create a foreign key linking the two tables Going from 2NF to 3NF Ans- Create a third table with its own primary key Create foreign keys to link the table