Update Operations/Dealing with Constraint Violations

[@sachinsudaraka6397]

Thank you sir...

[@Aditya-ot7ib]

Sir?

[@amarankali646]

Thank you🙏

[@shreeramkaushikk.v7729]

Thank you😄

[@aps8011]

9:06 : how it violates referential integrity constraints after updating 1330 to 1331? The referenced relation has foreign key 1331

[@ridwanmugdha7623]

I think it violates only Key Constraints not Referential Integrity Constraints.

[@itsbxntley2970]

Maybe conflicting values since 1331 will now refer to two tuples which are supposed to be unique too

[@mohamedfathy002]

because there is already a tuple that contains the id 1330 in the foreign key so if we change the value 1330 in the key attribute to any other number, the number 1330 would not exist which violates the referential integrity and at the same the key constraint is violated because we cannot have double values in the key attribute since she attempted to modify 1330 to 1331 so we will have two tuples with the same value in the primary key which obviously violates the key constraint

[@santhipriyapriya9828]

Thank you...

[@naifhussain7426]

Very suppeerrbbb adress beautiful teaching

[@anil2009]

continue the videos please

[@amwalonline]

Thanks

[@recapbaba007]

Thanking you

[@arsenemuhire4198]

Hello, Is it possible that foreign key in Relation(Table) can have same values ??

[@swastikbhandari2644]

Yes

[@anaolatinafu8629]

Proud of ETHIOPIA ETHIO AIRLINES + DR.ABIY

[@abdulelahal-yousuf1198]

how is the primary key of WORKS_ON called EMP_ID has 1331 repeated?

[@abdulelahal-yousuf1198]

oh its a composite primary key of both emp_id and pno

[@hrdyasham7330]

I have a doubt miss....how can empid be same in delete operations ...will it not voilte key and referential integrity constraints?? please answer

[@chethankh6652]

In primary key it I'd not same

[@sameermeshram3062]

Upload the video of control system sir

[@52_shiwani29]

There are some errors

[@amwalonline]

Could u mention them here? for the sake of learning :)

[@hrdyasham7330]

@@amwalonline yeahh even I think so ...how empid could be same... won't it be a violate referential integrity

[@asomy44]

@@hrdyasham7330 No it won't, because Emp id and Pno are the keys not only the Emp id so there's no violation.

[@balakrishnaprasad8928]

Complete remaining java programming lectures

[@ashwinimirajkar6098]

thanks