Made Easy FLT

Question

Does a Schedule exist which is serializable and  neither view serializable nor Conflict serializable?

I am not aware of this fact but in a  standard book (Fundamentals of Databses by B.Navathe),

 I found someting useful, not sure wether it exactly delivers the solution.

Answer 1

Yes it does exist. It is because Conflint Serializable and View Serializable are sufficient conditions for a schedule to be serializable and not a necessary conditions. It means if a schedule is Conflinct Serializable or View serializable, it will be surely serializable. But not being conflinct and view serializable, doesn't guarantee that schedule is not serializable. So, a schedule can exist which is serializable and neither view serializable nor Conflict serializable.