This should remove all the duplicate columns from the table. The normal forms can be divided into 6 forms, and they are explained below. What are all the different normalizations?ĭatabase Normalization can be easily understood with the help of a case study. It is also process of introducing redundancy into a table by incorporating data from the related tables.ġ3. The main aim of Normalization is to add, delete or modify field that can be made in a single table.ĭeNormalization is a technique used to access the data from higher to lower normal forms of database. Normalization is the process of minimizing redundancy and dependency by organizing fields and table of a database. This means, it returns all the rows from the left hand side table and all the rows from the right hand side table.
Simply, it returns all the rows from Left hand side table even though there are no matches in the Right hand side table.įull join return rows when there are matching rows in any one of the tables. Left join return rows which are common between the tables and all rows of Left hand side table. Simply, it returns all the rows from the right hand side table even though there are no matches in the left hand side table. Right join return rows which are common between the tables and all rows of Right hand side table.
Inner join return rows when there is at least one match of rows between the tables. There are various types of join which can be used to retrieve data and it depends on the relationship between tables. What are the types of join and explain each? Keys play a major role when JOINs are used.ġ0. This is a keyword used to query data from more tables based on the relationship between the fields of the tables. Relationship needs to be created between two tables by referencing foreign key with the primary key of another table. There can be many unique constraint defined per table, but only one Primary key constraint defined per table.Ī foreign key is one table which can be related to the primary key of another table. This provides uniqueness for the column or set of columns.Ī Primary key constraint has automatic unique constraint defined on it. It means, Primary key values cannot be NULL.Ī Unique key constraint uniquely identified each record in the database. This is a special kind of unique key, and it has implicit NOT NULL constraint. A table has specified number of column called fields but can have any number of rows which is called record.Ī primary key is a combination of fields which uniquely specify a row. Columns can be categorized as vertical, and Rows are horizontal. This is also known as structured form of data which can be accessed in many ways.Įxample: School Management Database, Bank Management Database.Ī table is a set of data that are organized in a model with Columns and Rows. Database is nothing but an organized form of data for easy access, storing, retrieval and managing of data.
0 kommentar(er)
