(Solved): 2. (30pts) Use below table to answer vour auestions. a. Give two examples (sources) of data redund ...

2. (30pts) Use below table to answer vour auestions. a. Give two examples (sources) of data redundancy in the given table. A source of redundancy is a subset of columns that tend to repeat within the table. Example1: Example 2 : b. Show why redundancy is undesirable by describing potential problems that may occur when one updates content of the table. To illustrate your case you must use an example/source from the ones you provided in answer to a. c. Show how you can remove the data redundancies by creating a new database where unnecessary redundancies are unlikely to occur. In your Crow's Foot $$\mathrm{ERD}$$ for the new database show all the tables and all the fields in each table. You should also show connectivity. Determine the optionality in each case by examining the actual data provided. Assume the given data fully represent all the requirements for the database. Your ERD must capture all the relationships you can detect in the given data. Must show all fields. Must label $$\mathrm{PK}$$ and $$\mathrm{FK}$$.