Connect with knowledgeable individuals and find the best answers at IDNLearn.com. Discover trustworthy solutions to your questions quickly and accurately with help 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.

Sagot :