Relational VS Nonrelational Databases – the Difference Between a SQL DB and a NoSQL DB

postgelSQL access info

  1. Relational database
  2. Non Relational database

Relational database

  1. based on relational model
  2. use sql for manage + manipolation
  3. data in RDBMS is organized in Tables,Rows,Columns
  4. Each Table has a defined Schema
  5. Ex : postgres, MYsql,Oracal,Microsoft,My sql server ect

Cardinality

  1. 1 to 1 persone⇒ brith cartificate
  2. 1 to 1 (optional on one side) persone ⇒ driving licence
  3. many to 1
  4. many to many
  5. one to many order
  6. many to many course