C170 Performance Assessment Complete 2023

Document Content and Description Below

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 <P... rimaryKey> = <#>; 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 [Show More]

Last updated: 1 year ago

Preview 1 out of 2 pages