MySQLWorkbench
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
(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 .