Get comprehensive solutions to your problems with IDNLearn.com. Ask any question and receive timely, accurate responses from our dedicated community of experts.

There are two tables in a sales database. One Is “Order” and the other Is “People”. Order has Sales, Region, and Order_id. People has Sales_person and Region. If we were to add a third table named “Returns” with attributes Order_id and Returned, answer the following questions: 1: What would be the relationship between Order and Returns where if we create a modified table, we can see both the orders that were “True” and “False” under the Returned attribute? State the set operation and make a drawing to prove your point if necessary. 2: Prove this argument. If Order has Region and People has Region, then they can be merged. If Order has Order_id and Returned has it as well, then they can be merged. Therefore, the table where People] and Order was merged can be merged with Returned.