Databases/MongoDB/Mongoose Flashcards
What is SQL?
Structured Query Language. The language used for interacting with relational databases.
What is NoSQL?
A play on “SQL”, describing a type of database that doesn’t use SQL and is considered “non-relational”
The language used for interacting with relational databases
SQL
Another term for a non-relational database
NoSQL. This is just a play on the term SQL, but isn’t itself a real language.
What is a single resource called in a SQL database?
Record
What is a single resource called in a NoSQL database?
A document
What is the structure in a SQL/relational database called that contains multiple records?
Table
What is a table in a SQL database?
The structure in a relational database that contains multiple records
What is the structure in a NoSQL/non-relational database called that contains multiple documents?
Collection
What is a collection in a no-SQL database?
The structure in a non-relational database that contains multiple documents
What is a primary key?
In a SQL database, primary key refers to a record’s ID of the same table
What is a foreign key?
In a SQL database, foreign key refers to a record’s ID from another (foreign) table.
What is a model?
A representation of of the documents that will be saved to the database. Like a blueprint outlining all the properties of a database