Help me answer all the question below with proper tables,DFD and also the SQL code. I have attached the ERD diagram

$1.$ Identify the required tables in the system and normalize them up to $3$NF$.$

$2.$ Provide Data Flow Diagram showing the primary documents and tasks of the system and the flow of data among them.

$3.$Write the SQL queries to create the required tables

$4.$Design at least $10$ sample user interfaces to perform data operations including insertion, deletion, update, and search of information.