Normalize the following table, draw an Entity Relationship Diagram, and write an SQL Query to create each table. creat erd and offer datiels with pk and fk and 2nf and 3nf and 1nf , please offer datiels.. and write an SQL Query to create each table

(And ERD that has Four tables (each of them has attributes, PKs, FKs (if any), and the Attributes' Data type).

Snapshots of the SQL Queries (Use Snipping Tool to cut only necessary information).