Is deleting an entity with a foreign key atomic?

Is deleting an entity with a foreign key atomic?

References

Reference NO 1

http://stackoverflow.com/questions/13650004/is-deleting-an-entity-with-a-foreign-key-atomic

Reference NO 2

http://academic.udayton.edu/davesalisbury/classtuf/mis385/slides/385slides/fall_07_new/relational.ppt

Reference NO 3

http://www.computing.surrey.ac.uk/personal/st/A.Browne/CS263/Lecture5Notes.ppt

Reference NO 4

http://home.business.utah.edu/pactlc/chap%205.ppt

Reference NO 5

http://www.ou.edu/class/aschwarz/Database/chap6.ppt

Reference NO 6

http://inst.eecs.berkeley.edu/~cs186/sp07/Spring07Lectures/22-ER-Design.ppt

Reference NO 7

http://blogs.msdn.com/b/dsimmons/archive/2010/01/31/deleting-foreign-key-relationships-in-ef4.aspx

Reference NO 8

http://business.fullerton.edu/isds/rsinghania/is408review5.doc