Summary

Get a quick overview of what we’ve covered so far.

We'll cover the following

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.

Get hands-on with 1200+ tech skills courses.