CIS 515 STUDY Future Starts Here/cis515study.com CIS 515 STUDY Future Starts Here/cis515study.com | Page 16

redundant data and that this structure lacks normalization. The
database has the following characteristics:
•A table that stores all the salespersons. The table holds their
employee id, first name, last name and “Tours sold” field. The
“Tours sold” field is updated manually.
•A table that stores tour customer data and tours sold. The table
holds customer name, address, city, state, zip code, tour(s) selected,
number of persons in tour