1
.
You are a database architect for a company that develops different types of applications, including an ecommerce platform, a real-time analytics tool, and a computer-aided design system. Your job is to choose the right database management system for each application. You have these options:
- relational database management system (RDBMS)
- object-oriented database management system (OODBMS)
- NoSQL database
Based on this scenario, answer the following questions:
- Which DBMS should be chosen for the e-commerce platform and why?
- Which database management system would be most appropriate for the real-time analytics tool and why?
- Which database management system should be selected for the computer-aided design system and why?
2
.
Given the importance of security in database design, particularly in systems handling sensitive data such as a library management system, outline the security measures you would implement to protect the data.