Search code examples
databasenormalizationdatabase-normalization

Different normal forms for the table

I am confused with the normalization topic,so please give the normalization forms of the table contains the columns as shown below

EMPID, EMPNAME, DATEOFJOIN, PREVIOUS_EXP, DESIGNATION, MANAGER, Email, Mobile, Location , IMAGE

Solution

  • Don't worry much about normalization if you have only this much details for a database, you can organize your data as per your requirements. The below form looks good for me.

    EMPID, EMPNAME, DATEOFJOIN, PREVIOUS_EXP, DESIGNATION, Location

EMPID, Email, Mobile

EMPID, MANAGER

EMPID, IMAGE