Review the following textual description of a flat database table containing customer orders. Identify the specific normal form violations (1NF, 2NF, 3NF, BCNF). Propose a redesigned schema consisting of multiple tables with defined Primary Keys (PK) and Foreign Keys (FK) to achieve Boyce-Codd Normal Form (BCNF). Additionally, write the SQL CREATE TABLE statements for your proposed solution.