W3D1 Flashcards
What is a programming paradigm?
Is a way to classify the programming language according to their style.
What are 2 programming paradigms in Ruby?
- Imperative Programming: This style feeds step by step instructions for the computer to execute by explicitly writing each command.
- Declarative Programming: This style will describe the results that you want to achieve without explicitly writing the steps.
What does RDBMS stand for and what do they do?
Relational Database Management Systems is a way to organize data and their relationships, persists data, and query data.
What does query mean?
A set of instructions that describes what data to retrieve from a given data source.
What is persistence?
Persistence is the characteristic of state that outlives the process that created it.
How do you persist state?
To persist data, you must store the state as data in a database or data storage.
What is used as the unique identifier of a table row?
The primary key and by convention it is the id.
Describe the table.
Each table is a type of resource. Each row in a table is an instance of that resource and each column is data that is associated to each instance of said resource.
What is a database schema?
A database schema is the organizational design of your database tables and columns.
What are the 3 things you must decide on when implementing a database schema?
- ) The tables you will have
- ) What data columns to have
- ) The data type of each of those columns
What is a foreign key?
A foreign key is a value in a database table whose responsibility is to point to a row in a different table.
What does SQL stand for and what does it do?
SQL stands for Structured Query Language and is a domain specific language used to manage data held in RDBMS.
What is the naming convention of SQL tables?
snake_case and pluralized