2.What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure?
3. If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the file structure?

10. Given the file structure shown in Figure P1.9, what problem(s) might you encounter if building KOM were deleted?

End of Chapter 2 Problems 1-6:
1. Write the business rule(s) that govern the relationship between AGENT and CUSTOMER

2. Given the business rule(s) you wrote in Problem 1, create the basic Crow’s Foot ERD.

3.Using the ERD you drew in Problem 2, create the equivalent object representation and UML class diagram. (Use Figure 2.4as your guide.)