Databases are an essential component of modern software applications because they allow systems to store, manage, and retrieve data efficiently. Two major categories of database systems widely used today are SQL (Structured Query Language) databases and NoSQL (Not Only SQL) databases. SQL databases store data in structured tables and are known for their strong consistency and reliable transaction management. In contrast, NoSQL databases provide flexible data models and are designed to handle large volumes of rapidly changing data. This paper presents a comparative study of SQL and NoSQL databases, focusing on their key technical differences, advantages, and practical applications. The study also examines how students in the later stages of their computer science or information technology degree can decide which database technology is most suitable for their final year projects. Through a case study comparing an e-commerce system with a real-time analytics application, the paper demonstrates situations in which SQL or NoSQL databases may be more appropriate.
Shahzaib Jillani (Mon,) studied this question.