what is the sql for creating the relations and loading the files into the relations? be sure to include any key, foreign key, or check constraints that you see when creating the relations. include any transformations you do on the data to enable the data to be loaded/used and made consistent.