I've been thinking about how best to design for a particular situation, and I wonder if any of you have comments about what I've come up with. I've attached a JPEG of the design if that's easier to understand.
Situation:
Database to store information on one's running.
A person can run multiple times per day, and can run in different ways (sprint, jog, powerwalk, etc.):
-Table: runningSession with a session_id.
-runningSession table contains a FK date_id to the dates table
-runningSession table also contains a FK type_id
Each runningSession can have information about multiple laps stored
-Table: laps with a lap_id, time, and distance
-Table: laps_sessions that links to runningSession via session_id and laps via lap_id. Also contains a lapNumber to say which lap it was.
Is this properly normalized (see the attached JPEG if my description of my tables wasn't clear) and a good design? I think so, but I'm still learning database design.