SQL queries and the result set

SELECT Query This use for view tables with or without filters/conditions. Syntax SELECT * FROM table_name ; UPDATE Query This use for modify the existing records in a table. Syntax UPDATE table_name SET column  = value  WHERE condition ; DELETE   Query This used for delete existing records in a table. Syntax DELETE FROM table_name WHERE condition ;

Relational database

SQL statements of adding data

SQL statements of adding data; INSERT INTO table_name  VALUES (value1, value2);

SQL statements of table creation

create database statement; CREATE DATABASE database name; Create table statement; CREATE TABLE table_name (     column1 datatype,      column2 datatype);

Normalization of the Relation drawn using the ER Diagram

What is Normalizing? Normalizing is the process of organizing data to minimizing redundancy. If a database design is not perfect, it may contain anomalies, which are like a bad dream for any database administrator. Managing a database with anomalies is next to impossible There are three main anomalies; Update anomalies when we try to update one data item having its c…