Chapter 3
Answer 1
The normalization of the schema inside a DBMS provides a number of benefits, such as the following:
- Improved overall organization of the relationships
- Reduction in storage of redundant data
- Improved consistency of the data inside the database
- Better indexing of the data, which improves access to the data
Answer 2
The lazy loading in SQLAlchemy provides the developer with an option to use the select or joined modes, in which the lazy loading can be performed. When the developer goes with the select mode of loading the data, the loading of the datasets...