I was using
SQL in all my previous application and to understand the
Parse.com db storage, I wanted to know
I tried searching the differences between
NOSQL for past 2 days & I still don't understand how a relation works in
I learned that
NOSQL is schemaless and there's no structure like SQL. Let me brief my question in an example.
In a SQL application for School management, I would create a table
students which stores students' information. For marks, I'll have a
marks table which has a column
user_id that refers to
students table. I'll have one more table
subjects which will hold
So, if I change
sub_code in the
subjects table, that will simply reflect to the other tables where FOREIGN KEY is used by using ON UPDATE DELETE CASCADE.
Now my question is,
NOSQLdoesn't use NORMALIZATION, how will the data be stored? Should a single table (document in NOSQL) hold all the information that is in
If we dump all the information into one single table, how efficient will it be?
If we want to change a subject code, then we need to update all the documents, right? (In SQL, we simply change subject code in one table, since other columns in other table which are referencing this column subject code will simply update right rather than updating each single entries?)