#databases

What is Normalisation in database?

Let's consider an example to illustrate normalization in a database. Suppose we have a database that stores information about books and authors. Initially, we might design a single table to hold all the information: Table: Books Book IDTitleAutho...