How should you set up the database?

Set up the database with several interrelated tables. Separating information into related tables reduces unnecessary duplication and makes it easier to organize and update records. One large table can repeat the same details many times, while making a separate table for every city and state is usually too fragmented.

AI-written and checked against the verified answer.