Module 2 feedback

[louisrli]

#1 Introduction to Databases

• "In tech companies, there are different roles and specializations and many of them are focussed on data and databases" Consider making this section bullet pointed. Also explain that many companies have different titles for the same thing. I'd delete the line about "Database Developer"

1.1 Introduction to Relational Databases

• synomyous -- typo
• Advantages of RDBMS -- random spaces before colons in this section
• Advantages of RDBMS -- I don't think that relational DB necessarily has better security than other DBs, I think every production modern DB is going to have some type of authentication and permissions system (talking about point 5)

1.2 Relational Database Structure

• "Tables can have hundreds, thousands, sometimes even millions of rows of data." -- might be interesting to include an example of a big company's table size (HighScalability blog might have interesting stats here)
• One-to-one is probably the least important relationship, should be included last rather than first
• "If there are two entity type" grammar / capitalization check

1.3 Querying in SQL

It's good

2 Introduction to NoSQL databases

• "One of the most severe limitations of relational databases is that each item can only contain one attribute" I don't really understand this sentence -- might need a more concrete example
• Same thing about spaces before colons as last section

2.1 Introduction to MongoDB

• Perhaps emphasize why a collection scan is bad here: "MongoDB must perform a collection scan, that is, scan every document in a collection" (same would apply for RDBMS), perhaps mentioning that you don't want to loop through millions of items each time you do a query
• Maybe mention some common examples of practical aggregations in the aggregation section (don't need to explain but just mention, like summing or something)

2.2 Querying in MongoDB

• specifc -- typo
• I don't like the usage of uom in the example, which might encourage students to use hard-to-understand abbreviations as column names (I would have no idea what UOM was if I were only reading the schema, for example). unit would be good

2.3 Queries practice

Looks good

3 ORM / ODM

Looks good

3.1 Sequelize practice

There's also a sequelize-cli to autogenerate models that might be useful for the students to practice as part of the assignment

4 Other Popular Databases

• they"re typo