Union compatibility can be used in relationships where no integrity constraints are imposed between two or more relationships (Primary key and foreign key constraints) and the output we require is Cartsian product i.e each and every entity set of one relation is displayed as a combination with every entity set of another relation