Since the primary key is composed of report_id, product_type, product, product_code. And all other columns are not depend on part of this primary key. But description is dependent on product_code.

You can also use the ALTER TABLE statement to modify your table definitions later if needed. Here is an example of SQL code that corresponds to a simple ER diagram of customers and orders: ...