Tutor profile: Deb A.

Why do we do normalization of fields and tables of a database?

Normalization is done to optimize a database by minimizing redundancy and complexity of fields and tables and to avoid duplicate data or columns that can otherwise be stored in a single table.

How can I filter two or more columns simultaneously but independently in Excel?

We can utilize the advanced filtering method by following the steps below: 1. Ready your data and a criteria table with the criteria that you want to filter independently. Make columns with the same name from your data on the criteria table. If the filtering will not coincide with other criterion, put the value on a separate row (first row for the first column and so on). And if they will coincide, you can have the values of the said column on the same row. 2. After finishing the setup, go to Data tab. 3. On the Sort and Filter section, click on Advanced. 4. The Advanced Filter popup should appear. 5. Select an Action depending on where you want to have the results of your filtering. 6. On the List range, select the range of your data (including the column headers). 7. On the Criteria range, select the range of your criteria table (including the column headers). 8. If you choose, copy to another location on the action: On the Copy to, select where you want to put the results of your filtering. 9. You can also choose to have only the unique records to show on the results by ticking the box below the inputs. 10. Once done, click Ok.

How can you explain the common polymorphism implementation called method overloading in the simplest way?

Method overloading allows you to have multiple methods with the same name but different parameters.