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 main topics:
- Developing databases
- The MySQL Workbench GUI
- Creating a database
- Using Workbench to add a table
- MySQL table indexes and foreign keys
- Reverse engineering a database
