09-02-2022
Today's Foci
Focus 1
- What/How?
- Measure
Topic
UML, CRC, ERD diagramming
CRC appears to be the simplest way of creating a simple diagram for a database.
What is the equivalent UML; is it ERD? or classes?
When thinking of a class, what does it know, and what does it do
One to many rule
foreign key is within the one table reaching into the many table
Many to Many
will use a linking table
State
Databases contain state - remember this! Try to deeply conceptualize this!
the many appears in the ones table asa foreign key
Continuing Pair-solo before Lunch
Create a database-testing-environment
Makes a lot of sense to be honest
I haven't been thinking of the database as seperate, when I should have - that makes everything a lot clearer. Literally, as though 2 languages are interacting with one another (which they kind of are!)
Hmm - I need to dig into this more - I'm clear on a basic level, but how they interact and where we draw the boundary between one programme and the next, I remain uncertain. Perhaps the bash stuff will help - it seems to lean that way - think of them as active but mutually exclusive processes, where the process is an instance of the software? hmmm, maybe.
Databases - Production, Test, Dev
Useful Tactics
PUML skins
for plant UML, the theme can be changed with
@startuml
!theme {aws-orange}
...LOGIC...
@enduml
themes include
- aws-orange
- cerulean
- sandstone
- plain (professional)
- metal
- minty
- silver
- superhero
- superhero-outline
professionaltext is white! - sketchy
- sketchy-outline
- toy
- vibrant (professional)