1,056
edits
Changes
Jump to navigation
Jump to search
Line 6:
Line 6: + + + + + + + +
no edit summary
*Each Tuple should have a primary key (normally an arbitrary integer) that identifies a unique tuple. Natural keys (those based on attributes) are possible as well but less optimized.
*Each Tuple should have a primary key (normally an arbitrary integer) that identifies a unique tuple. Natural keys (those based on attributes) are possible as well but less optimized.
*Databases can be indexed to streamline queries.
*Databases can be indexed to streamline queries.
=Useful Wikipedia Pages=
*[https://en.wikipedia.org/wiki/Relation_(database)|Relation]
*[https://en.wikipedia.org/wiki/Database_normalization#Satisfying_EKNF|Database Normalization w/ step by step instructions w/ examples]
*[https://en.wikipedia.org/wiki/Associative_entity|Associative Entity, for resolving many-to-many cardinality]
*[https://en.wikipedia.org/wiki/Primary_key|Primary Key]
*[https://en.wikipedia.org/wiki/Database_index|Database Indexing]
*[https://en.wikipedia.org/wiki/Relational_database|Relational Database, lengthy overview]
=Working Prototype=
=Working Prototype=