Appendix D. Diagram of the Lunches Database
This appendix contains a diagram of the Lunches database that shows all the tables in the database and how they are related to each other. It contains a list of the join conditions to use when you are obtaining data from more than one table. The data validation rules are also shown here.
Figure . Diagram of the Lunches database.
The columns of the primary key are shown with a key symbol next to them.
The names of all the tables in the Lunches database begin with the prefix l_. This prefix shows that these tables are related and that they are all parts of a single system.
The lines between the tables show the ...
Get SQL Fundamentals, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
