Question 9

Question 1: A relational Database Model allows database users to analyze data thoroughly. To accomplish this, advanced commands such as UNION and INTERSECT may be used. Describe a business scenario where a UNION relational set operator may be used to merge two similar data sets. Within the context of your business scenario, analyze the analysis and data consistency advantages of using a UNION operator rather than simply merging two data sets into one result table. Suppose you are tasked with finding common data elements amongst various data sets. Specify how an INTERSECT operator may assist you in accomplishing this task. Construct a query that can perform the same function as the INTERSECT operator without using the "INTERSECT" syntax within the query. Question 2: "Searching Textual Documents" Please respond to the following: • Your company has been hired to design a product that will provide searches of textual documents and database querying. Your design team has not developed a product like this before. Examine the challenges associated with searching in textual documents and database querying. Describe how the five-stage search framework shared in Chapter 13 could be used to overcome those challenges. • Assess current multimedia document search techniques and suggest three techniques to improve multimedia search experiences. Explain why you chose to recommend each of the techniques you suggested.