I want to understand Normalization in depth , I have googled about it but i got to know about it in a very basic level. I want to insert/update/delete data in a table using a Store Procedure(UPSERT/MERGE) rather than the syntax used to insert data into the Table directly.
What I have tried:
I tried creating Tables with these parameters (EmpID,EmpName,Gender,Salary,AnnualSalary,DepatName,DeptHead,DeptLocation) and further divided into emp table and dept tables and trying to create a Upsert Store procedure and i am struct at creating a UPSERT Store procedure.