1. What type of database is the best fit for the complex query intensive environment?
SQL
2. What type of database is the best fit for hierarchical data storage?
NoSQL
3. Describe the differences in scalability between a SQl and NoSQL database as though you were speaking to a non-technical friend.
SQL databases scale with how fast your computer hardware is. NoSQL databases scale more the more computers you have.
1. Among data tables, what is a one-to-many relationship and how do we “relate” them?
In one to many, one record in a table can relate with many other records in another table.
2. Prior to designing your relational database, it might be useful to ___ a ___ of the database tables and their relationships.
Prior to designing your relational database, it might be useful to Create a Diagram of the database tables and their relationships.
3. Explain the difference between a primary and foreign key.
A primary key is how each row of a table is internally identified. Foreign keys are columns that will match the primary key in another table.
1. How do we treat keywords and parameters differently in SQL syntax?
The
2. Define normalization within the context of schemas and data.
The goal of normalization is to prevent or avoid storing duplicate data.
3. Explain the difference between one-to-one, one-to-many, and many-to-many relationships to a non-technical recruiter.
One to one is where one box in your excel spreadsheet in a table can match one box in other excel spreadsheets.
One to man is where one box in your excel spreadsheet can match one or more boxes in your excel spreadsheets.
Many to many is where many boxes in your excel spreadsheets match one or more boxes in your excel spreadsheet.