#250 · Data modelling · 6.6 minData Modelling Basics: Entities, Keys, Relationships
With foreign key checks off, SQLite accepted a repair for bike 99, which does not exist.
Python 3.12.158 videos tagged "database design".
#250 · Data modelling · 6.6 minWith foreign key checks off, SQLite accepted a repair for bike 99, which does not exist.
Python 3.12.15
#252 · Data modelling · 6.9 minThree ordinary changes broke a flat table of 5 rows; four tables took all three.
Python 3.12.15
#253 · Data modelling · 6.5 minA source renumbered 3 customers; natural and hash keys ended up with 6 rows, a surrogate key kept 3.
Python 3.12.15
#254 · Data modelling · 6.8 minWithout constraints SQLite loaded all 8 rows, 5 of them bad; with constraints only 3 got in.
Python 3.12.15
#255 · Data modelling · 6.5 minFour students' fees add up to 3,200 pounds; summed after joining through a bridge table they came out as 5,500.
Python 3.12.15
#267 · Data modelling · 6.9 minThree orders' shipping adds up to 9 pounds; after flattening the JSON into item rows it summed to 17.
Python 3.12.15
#272 · Data modelling · 6.7 minA retry loaded 3 payments twice into a table with no key, and 75 pounds became 150.
Python 3.12.15On one made-up day, a wide table I wrote to fail could not find the busiest hour, overstated one driver's earnings by 54.18, and gave a surge of 1.0 where the schema said 1.8.
Python 3.12.15