Skip to content

Instantly share code, notes, and snippets.

@vaidashi

vaidashi/gist:d4e243b37dce3bde085e12b396843acd

Created June 28, 2017 16:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vaidashi/d4e243b37dce3bde085e12b396843acd to your computer and use it in GitHub Desktop.
Save vaidashi/d4e243b37dce3bde085e12b396843acd to your computer and use it in GitHub Desktop.
Download ZIP
Database Visualization
Raw
gistfile1.txt
What is a primary key?
Unique identifier for a particular record in a database.
What is a foreign key?
An identifier in one table that refers to a primary key in another.
What is a schema?
Design and conceptual layout of the relationships our project will contain.
How does a one-to-many relationship differ from a many-to-many relationship?
Many-to-many would require a join table in order to build the relationship since they both will reference multiple items of each other.
Describe the relationship between a foreign key on one table and a primary key on another table.
An identifier in one table that refers to a primary key in another.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment