See what we can offer to your school
"SimpleStudy just makes sense...”
Get the best plan for your school
15 cards from this deck
Entity Relationship Diagram - models database structure
Unique identifier for each record in a table
No two records in the table are identical
Links to primary key of another table, establishes relationship
Used for data retrieval; allows quick access to records
Not necessarily unique (unlike primary keys)
Each record in one table linked to only one in another
Single record in one table linked to multiple in another
One-to-Many (1:M)
Multiple records in one table link to multiple in another
Create a junction table with foreign keys to both tables
Associative table with foreign keys linking back to both tables
Combination of fields used as primary key
Rectangles
1:1, 1:M, or M:M
Select your subjects, and get access to A+ resources today.