learn-py4web.github.io

Unit 12: Database design

In this unit, you learn how to design the database layout. We discuss how (and why) to organize the database in multiple tables. As a running example, we design a database to keep track of classes, offerings of classes in quarters, and student registration to particular class offerings. We show you how to query information across multiple tables. We then show you how to insert information in multiple tables by developing a sample site where students can register to classes.

Resources

Resources in boldface are strongly recommended readings.

• Pydal documentation for web2py. This applies also to py4web.
• Pydal documentation for py4web. This is essentially the same as the above.
• The SQL query language.
• Relational databases of which mysql and postgres are examples.
• The relational model, the data model on which relational databases such as mysql and postgres, are based.

Code

• Class registration code.

Videos

• Designing a database schema (YouTube).
• Querying multiple tables in a database schema (YouTube).
• An example: registering for classes (YouTube).