What problem would you encounter if you wanted to produce a list by city? How would you solve this problem by altering the file structure? Answer: Using this table (FIGURE P1.1) if I want to generate a list of cities it is very difficult to generate it at the same time. Huge upfront work is needed on the address variable because it is a composite address where the city name is available but difficult to separate into a single query. Keeping this in mind, we need to more carefully design the database structure where we can easily generate the required outputs at any time, and then create a separate city variable to solve the problem.D. What data redundancies do you notice in Figure P1.1? How could these redundancies lead to anomalies? Answer: Manager_Phone and Manager_Address are data redundancies in Figure P1.1. The presence of unnecessary data in the database is the definition of data redundancy. Don't include one-to-one relationship data in a table. Here if Project Manager and Manager_Phone and Manager_Address have one to one relationship and no duplication, then what is corrupted by redundancies and Manager_Phone and Manager_Address its unnecessary data and database creation level is bigger. E. List and describe five types of data that you will often encounter when working