Database Theory
Column -
Cursor - a pointer to one row in a defined result set
Record - synonymous with a "row".
Relvar -
Result Set - the result of a query as a non-permanent table of rows
Row -
Schema - "structure of a database described in a formal language supported by the database management system (DBMS)" (1)
Table -
Tuple - synonymous with a "row".
View -
Cartesian Joins/Cartesian Product
Cartesian Joins/Cartesian Product
The Cartesian product is named after René Descartes and originated from Cartesian geometry
By Quartl - Own work, CC BY-SA 3.0, https://commons.wikimedia.org/w/index.php?curid=22436861
Normalisation
Normalisation
1NF
2NF
3NF
Bibliography
Bibliography
https://fauna.com/blog/demystifying-database-systems-part-4-isolation-levels-vs-consistency-levelshttps://queue.acm.org/detail.cfm?id=3419941 (The Life of a Data Byte)https://relinx.io/2020/09/14/old-good-database-design/https://www.brentozar.com/archive/2020/10/databases-are-like-walk-in-coolers-tsql2sday/https://freecomputerbooks.com/Databases-Types-and-the-Relational-Model-The-Third-Manifesto.htmlhttps://www.dcs.warwick.ac.uk/~hugh/TTM/https://www.dcs.warwick.ac.uk/~hugh/TTM/documents_and_books.html
Lock/Mutexhttps://en.wikipedia.org/wiki/Lock_(computer_science)
BTREE Indexeshttps://hinty.io/devforth/sql-query-optimization-understanding-key-principle/
SQLhttps://blog.arctype.com/sql-50-years/
QUELhttps://www.holistics.io/blog/quel-vs-sql/
Cartesian Joins/Cartesian Producthttps://en.wikipedia.org/wiki/Cartesian_producthttps://www.tutorialspoint.com/sql/sql-cartesian-joins.htm
Codd's Twelve Commandmentshttps://en.wikipedia.org/wiki/Codd%27s_12_rules
Schemahttps://phoenixnap.com/kb/star-vs-snowflake-schema(1) https://en.wikipedia.org/wiki/Database_schema
Cursorshttps://en.wikipedia.org/wiki/Cursor_(databases)https://learn.microsoft.com/en-us/sql/relational-databases/cursors
Heaphttps://www.geeksforgeeks.org/heap-data-structure
Result Sethttps://en.wikipedia.org/wiki/Result_set
Row/Tuplehttps://en.wikipedia.org/wiki/Row_(database)
Columnhttps://en.wikipedia.org/wiki/Column_(database)
Relvarhttps://en.wikipedia.org/wiki/Relvarhttps://freecomputerbooks.com/Databases-Types-and-the-Relational-Model-The-Third-Manifesto.html
Stringhttps://www.geeksforgeeks.org/heap-data-structure
Lock/Mutexhttps://en.wikipedia.org/wiki/Lock_(computer_science)
BTREE Indexeshttps://hinty.io/devforth/sql-query-optimization-understanding-key-principle/
SQLhttps://blog.arctype.com/sql-50-years/
QUELhttps://www.holistics.io/blog/quel-vs-sql/
Cartesian Joins/Cartesian Producthttps://en.wikipedia.org/wiki/Cartesian_producthttps://www.tutorialspoint.com/sql/sql-cartesian-joins.htm
Codd's Twelve Commandmentshttps://en.wikipedia.org/wiki/Codd%27s_12_rules
Schemahttps://phoenixnap.com/kb/star-vs-snowflake-schema(1) https://en.wikipedia.org/wiki/Database_schema
Cursorshttps://en.wikipedia.org/wiki/Cursor_(databases)https://learn.microsoft.com/en-us/sql/relational-databases/cursors
Heaphttps://www.geeksforgeeks.org/heap-data-structure
Result Sethttps://en.wikipedia.org/wiki/Result_set
Row/Tuplehttps://en.wikipedia.org/wiki/Row_(database)
Columnhttps://en.wikipedia.org/wiki/Column_(database)
Relvarhttps://en.wikipedia.org/wiki/Relvarhttps://freecomputerbooks.com/Databases-Types-and-the-Relational-Model-The-Third-Manifesto.html
Stringhttps://www.geeksforgeeks.org/heap-data-structure