Summary

Learning outcome

In this chapter, we learned a database schema design for the simple customer relationship management system. The main objective was to learn and practice creating relationships between tables using foreign key constraints. Relationships between tables essentially mean data references from one table to another. We covered how to create a unique order number and insert inaccurate data. We also covered how to fix different issues using foreign keys.