Appendix B Summary

Appendix B introduces relational databases. It is designed for students with no prior database experience or those needing a refresher on basic concepts and terminology.

The appendix uses a fast-food restaurant example to illustrate key database concepts. It explains the structure of database tables, the relationships between tables (one-to-one, one-to-many, many-to-many), and the use of primary and foreign keys. The document introduces Entity-Relationship Diagrams (ERDs) and relational schemas as ways to visually represent database structures. It also covers the concept of database normalization, emphasizing the importance of storing information efficiently and avoiding redundancy.

The appendix concludes with a practice problem that asks students to design a database for a fast-food restaurant's inventory purchases and payments process. This exercise requires students to apply the concepts learned by creating an ERD, converting it to a relational schema, and implementing the database in Microsoft Access. Overall, the document provides a foundational understanding of relational database concepts and their practical applications.