如何使用规范化删除冗余？

I have XML in which all the customer information is stored. Whenever my PHP code runs, it inserts the customer data from XML into the database. Here is the table. Not all the customer are web, so I have saved all the customer information directly to one table called "customer".I have XML in which all the customer informatio