# SQL (structured query language) / RDBMS (Relational DBMS) - Table- row (table format) (tabular design) - table-table relation (primary, foreign key) - define schema (schema is collection of DB objects associated with one particular DB username. Logical structure of data.) - insert, fetch, update, remove (CURD) -> Create, Update, Retrieve, Delete - Example: MySql, MS-SQL (includes defined property (eg. id, name)) # Distributed DBMS (Non- RDBMS) - Collection (table )-> documents (but no relation) - No Schema - Documents (JSON Objects) within collection - is highly scalable and can includes various property (eg. id, name, address..), can define field - Example: No SQL type (MongoDB) and nested object - MongoDB is a general-purpose, doc-based, distributed DB built for modern app developers and for the cloud era. Global cloud DB on AWS, Azure. -Mongodb automatically set id (object id) unique key (primary key) Important Command (MongoDB): mongo (sh...