@@codecrushers21 I have a question. In the db.employee the department ID is NULL but in the db.depart it is NOT NULL. I tried to alter the value to not null in db.employee but it is giving me error and I couldn't save the change. What should I do to correct it ya?
You should check if there are null value of department id in db.employee. There must not be any null value if you want to make it not null. If the problem continue send us an screenshot, so we can help you
@@codecrushers21 understood! Thanks for the guidance! I was studying today planning to go through part 4 but I ended up revising part 3 as I needed to create the gender table and put all the data before I can proceed. 🤣🤣Loving your videos! Pretty sad that there is only 5 part, nevertheless very very helpful.
Thanks for the greatvideo and please go on. We made 2 tables with each have theire own primary key, but suddenly u say we are going to make the foreign key the department id. But how can it be a foreign key if we just made it a primary key?
Yes indeed Department id is a primary key in department table but it is going to be a foreign key in the department id column of the other table Employee.
THANK YOU!
Thankyou so much for watching! Your support means everything
@@codecrushers21 I have a question. In the db.employee the department ID is NULL but in the db.depart it is NOT NULL. I tried to alter the value to not null in db.employee but it is giving me error and I couldn't save the change. What should I do to correct it ya?
You should check if there are null value of department id in db.employee. There must not be any null value if you want to make it not null. If the problem continue send us an screenshot, so we can help you
@@codecrushers21 understood! Thanks for the guidance! I was studying today planning to go through part 4 but I ended up revising part 3 as I needed to create the gender table and put all the data before I can proceed. 🤣🤣Loving your videos! Pretty sad that there is only 5 part, nevertheless very very helpful.
Thanks for the greatvideo and please go on. We made 2 tables with each have theire own primary key, but suddenly u say we are going to make the foreign key the department id. But how can it be a foreign key if we just made it a primary key?
Yes indeed Department id is a primary key in department table but it is going to be a foreign key in the department id column of the other table Employee.