beginning to make changes to reflect new db design:
updated to change categoryId > categoryID and ParentCategoryId > parentCategoryID.