Sometimes your single table isn’t big enough anymore. Your data has become more complex, and that one table you’ve been using just isn’t cutting it. Your single table is full of redundant data, wasting space and slowing down your queries. You’ve gone as far as you can go with a single table. It’s a big world out there, and sometimes you need more than one table to contain your data, control it, and ultimately, be the master of your own database.
Greg’s lonely friend Nigel has asked Greg to help him find a woman to date with similar interests. Greg begins by pulling up Nigel’s record.
contact_id: 341 last_name: Moore first_name: Nigel phone: 5552311111 email: email@example.com gender: M birthday: 1975-08-28 profession: Rancher city: Austin state: TX status: single interests: animals, horseback riding, movies seeking: single F
interests column isn’t atomic; it has more than one type of the same information in it. He’s worried it won’t be easy to query.
Greg adds Nigel’s request to his TO DO list:
Greg’s decided not to change the
interests column at all. He’s willing ...