Merge relation is important because
Correct answer: C. Both A and B
- A. Different views may need to be integrated.
- B. New data requirements may produce new relations to be merged.
- C. Both A and B
- D. To decrease the cardinality of a relation.
Explanation
The correct answer is Both A and B.Different views may need to be integrated. In a database, different users may have different views of the same data. For example, a salesperson might see a list of customers and their contact information, while a manager might see a list of customers and their purchase history. Merging relations allows you to combine data from different views into a single relation.New data requirements may produce new relations to be merged. As your database evolves, you may need to create new relations to store new data. Merging relations allows you to combine these new relations with existing relations.In conclusion, merging relations is a useful technique for integrating data from different views and for combining new data with existing data.
Last updated
About Networking and Internet
Networking covers LAN, MAN, WAN and wireless networks, network topologies, transmission media, devices such as switches, routers and modems, and the OSI and TCP/IP models. Internet concepts include IP addresses, DNS, URLs, web browsers, email, protocols such as HTTP, HTTPS, FTP and SMTP, and basic network security.
Practise Networking and Internet
452 free Networking and Internet MCQs from Computer Science and IT, each with the correct answer and an explanation. Unlimited attempts, no account needed.
Exams that ask Computer Science and IT questions like this
Computer Science and IT is on 40 papers prepared for on TestUstad, and all of them draw the same bank, so this question is worth knowing for every one of them.