Chapter 2: Creating a Database
In this chapter, you will learn about data modeling and the differences between a physical database and a conceptual database. Additionally, you will learn about Entity-Relationship (ER) diagrams and Enhanced Entity-Relationship (EER) diagrams and how they assist with data modeling. Following this, you will create indexes and foreign keys and learn how to generate them using the Workbench Graphical User Interface (GUI).
By the end of the chapter, you will have gained an understanding of how you can interact with a MySQL server. This will include building new databases, creating tables, structuring tables, building, and visualizing relationships, and creating indices.
In this chapter, we will cover the following ...
Get The MySQL Workshop 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.
