INSERT Auto Incremented PK from Table A into FK of Table B

Question

Sir Is there any option to make PK auto increment from tbl_A to the FK in tbl_B? in case of tbl_Division divisionId in PK(IDENTITY) divisionName classId(FKIDENTITY in tbl_Class) if I enter divisionName divisionId will be generate 1  but My doubt is would the classId also increament same as tbl_Class date to tbl_Division?

Riyaz Akhtar · Answer

Check below code insert into tbl_Class(classNamenoOfseats) values('10th'50) declare @classId numeric set @classId=@@IDENTITY INSERT INTO tbl_Division: (divisionNameclassId) VALUES('divisionName'@classId)

Bineesh VP · Answer

Sir I am upset of not to have a clear idea on SQL Normalization. Here I attached a MS Word File includes my doubts is been included in the form of questions. I request you to send me the answers for all these questions.

Ravi Shekhar · Answer

Hi bineesh  You can make PK auto increment from tbl_A to the FK in tbl_B. and it will work properly.

Bineesh VP · Answer

I am very sorry to say that this code is working but the output is not i expected auto increment of classId(PK) from tbl_Class tbl_Division where classId is Fk not happening.