How should you set up the database?

Set up the database with several interrelated tables. Separating related information into tables reduces unnecessary duplication and lets the tables connect through shared fields, such as IDs. One large table can repeat information, while separate tables for every city and state would be an unnecessarily rigid design.

AI-written and checked against the verified answer.