Relational databases have been one of the most widely used and most common forms of software systems for the storage of data since the 1970s. They are highly structured and store data in the form of tables, that is, with rows and columns. Structuring and storing data in the form of rows and columns has its own advantages; for example, it is easier to understand and locate data, reduce data redundancy by applying normalization, maintain data integrity, and much more.
But is this the best way to store any kind of data?
Let's consider an example of social networking:
Mike, John, and Claudia are friends. Claudia is married to Wilson. Mike and Wilson work for the same company.
Here is one of the possible ways to structure this data in a relational ...