Need a way to redesign tables such that there is minimal redundancy
Use "Normal Forms" to resolve your tables into a precise table which will contain both table data information, there are many Normal Forms, so please read about Normal Forms based on your requirements. Other way is that you can have a foreign key from first table in second table, so that you may not require to store first table data again in second table, while accessing in query u can put condition on that foreign key and access both table data rather than using first table data again in second table. I hope you got it, if not please let me know!!