DATABASE




The Process of Normalization:

            Normalization is a formal technique for analyzing relations based on their primary key and functional dependencies. Three normal forms were initially proposed called First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF). E.F. Codd introduced a stronger definition of third normal form called Boyce–Codd Normal Form (BCNF) higher normal forms that go beyond BCNF were introduced later such as Fourth Normal Form (4NF) and Fifth Normal Form (5NF).
           Normalization is often executed as a series of steps. Each step corresponds to a specific normal form that has known properties

Comments

Post a Comment

Popular posts from this blog

Oracle Cloud Database

  Oracle Cloud Database   Today we are going to learn about oracle database. First question is, what is oracle database? Then we are going to know, what is SQL query? After that we discussed about, how many types of queries are?     What is Oracle Database? Oracle word means who do the prophecy. Oracle Company is always work for future. Oracle is used worldwide in different organizations. Oracle is software that efficiently organizes data in a relational manner. Oracle Databases are very efficient to keep data back, maintaining or restoration of data is done by oracle database.     What is SQL query? SQL Stand for Structure Query Language. It is used to managing data held in relational database management system.   Select Query has Three Parts First part of query called Select , second part called From and third part is called Where   Select From Where     *...
Read more