fix BCNF statement and add data snippets