Describe how the notion of union and intersection apply to retrieving records in databases.
Discuss the notion of the logical "or" and the logical "and" in computer programming (coding) or flowcharts. Why is it important to know how to apply these correctly?