Ecart 6 has a more streamlined checkout experience and has a mobile friendly shopping cart. It also supports MySQLi. Those are the biggest changes.
You don't need to set up foreign keys in your database itself. You just create the table and the code on the page maintains the relationship.