From the course: Learning MySQL Development
Join today to access over 24,900 courses taught by industry experts.
Display database relationships with reverse engineering - MySQL Tutorial
From the course: Learning MySQL Development
Display database relationships with reverse engineering
- [Narrator] If you have only a small database then understanding the primary and foreign key relationships between tables is easy. Only a few tables means only a few relationships. However, if you have a larger, more complex database like the sample sequila database from MySQL, then understanding the foreign key relationships can be more tricky. It's possible to go from table to table looking at indexes to find foreign keys but it's slow and it's easy to lose track. Fortunately, the MySQL Workbench has a better solution, database models. A database model contains all the structural information about the database. It's tables, views, functions, and everything else including the relationships between tables. It does not, however, contain any data but that's the point. It's small and portable and it doesn't require any connection to the DBMS. You can send a database model over email to a colleague for review for instance.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
-
Create a database2m 13s
-
(Locked)
Create a table5m 51s
-
(Locked)
Use CREATE and ALTER to define a table3m 55s
-
(Locked)
Primary keys and foreign keys2m 37s
-
(Locked)
Display database relationships with reverse engineering3m 56s
-
(Locked)
Load bulk data3m 50s
-
(Locked)
Challenge: Create a normalized movies table1m 3s
-
(Locked)
Solution: Create a normalized movies table7m 4s
-
-
-
-
-