· 9 years ago · Oct 19, 2016, 05:56 AM
11. First rule: Each column name is unique, it should repeat, for example: 2 column name should not repeat in one column. Second rule: The entity should be considered already in 1NF and all attributes within the entity should depend solely on the unique identifier of the entity. Third rule: The entity should be considered already in 2NF and no column entry should be dependent on any other entry (value) other than the key for the table. If such an entity exists, move it outside into a new table.
22.
33. The PRIMARY KEY constraint uniquely identifies each record in a database table. A FOREIGN KEY in one table points to a PRIMARY KEY in another table. The CREATE INDEX statement is used to create indexes in tables. Indexes allow the database application to find data fast; without reading the whole table.
44. E saris mxolod magaliti , mand sxvanairi ikneba.
55. Indexis shekmna
66. CREATE INDEX index_name
7ON table_name ( column_name)