1,022
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + + +
no edit summary
=Simple Example=
=Database Basic=
*Relational databases (e.g. MySQL) are probably the most common. Essentially they store data in a set of 2D tables (relations) that follow certain rules of normalization and can be linked to each other via relational algebra (mostly set theory type functions).
*To address problems encountered when trying to interface a RDBMS with an object-oriented programming language, alternative non-relational database structures (e.g. XML, NoSQL, Hierarchical, Network) are available and may have advantages in certain situations.
*Tables (Relations/Relvars) are made up of Rows (Tuples/Records) and Columns (Attributes/Fields) where the intersection at a certain cell is called a value.
*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.
=Working Prototype=
{| class="wikitable sortable"
{| class="wikitable sortable"
! Disease !! Risk Factors !! Associated Conditions !! Complications !! Symptoms !! Vitals !! Signs !! Labs !! Imaging !! Studies
! Disease !! Risk Factors !! Associated Conditions !! Complications !! Symptoms !! Vitals !! Signs !! Labs !! Imaging !! Studies