MySQLWorkbench

You can use whatever you want to draw the diagrams, but you may find MWB useful for SQL and accessing our server. THere are also MySQL extensions for VSCode.

Installing MWB

Visit Lab0 and follow instructions there

Remind them about the M1 issue (use brew)

Demonstrations

Documentation

Color key for ERD diagrams

Colored icons in Tables

(the above is from Jan on StackOverflow)

Create new diagram with

  • Person: Net_ID, LName, FName
  • Address: Address_ID, Street1, street2, city, state, zip
  • Connect a 1:n from Person to Address and note the fields that arise.

Show them Sakila

Available on our examples directory here

Activity

Back to slides for Lecture 04 and the activity on slide 19 there - see if you can create those tables .