This question is regarding sql (creating tables and populating the tables with data from 3 csv files and an xml file).

I have already populated the first 3 tables (Pets, supplies, and customers) with info from the csv files as shown in the loadData function in the python file.

For the rest of the tables, they need to be populated with data from the transaction.xml file (attached in this question).

Pls complete the for loop under loadData (I have started it but it doesnt seem to work so you can either fix it or write a different one that works)

Thanks in advance

CREATE TABLE Pets( ID TEXT PRIMARY KEY, Name TEXT, Species TEXT, Color TEXT, Age INT, Price DECIMAL) CREATE TABLE Supplies UPC INT PRIMARY KEY Name TEXT, Price DECIMAL) CREATE TABLE Customers ( INT PRIMARY KEY ID Name TEXT, Phone TEXT, Address TEXT); AUTOINCREMENT CREATE TABLE Pets( ID TEXT PRIMARY KEY, Name TEXT, Species TEXT, Color TEXT, Age INT, Price DECIMAL) CREATE TABLE Supplies UPC INT PRIMARY KEY Name TEXT, Price DECIMAL) CREATE TABLE Customers ( INT PRIMARY KEY ID Name TEXT, Phone TEXT, Address TEXT); AUTOINCREMENT