Given raw data set $(.$csv$)$ contains $10$ columns and $10000$ raws Rows are random data about accidents in NY from $2014-2024$ yy Columns are : 'CRASH DATE', 'CRASH TIME', 'BOROUGH', 'ZIP CODE','LOCATION', $\text{'}$ON STREET NAME', 'NUMBER OF PERSONS INJURED','NUMBER OF PERSONS KILLED', 'CONTRIBUTING FACTOR VEHICLE $1\text{'},$'CONTRIBUTING FACTOR VEHICLE $2\text{'}$To solve this projectDesign an entity relationship diagram using $3+$ entities using data set. $($You can make up relational data for joining purposes to data set. Keep the ERD simple.$)$ ThenCreate a database with tables, views, and any other construct to represent your ERD $($ then will need to preload database with data from dataset and any other related data. $)$ Create and execute following SQL statements: define $1$ or more views, variables, temp tables, scripts, dynamic SQL$,$ Stored Procedure, User defined function, and at least one trigger. Show all SQL Code with executed resultsComment $/$ document code and explain what each piece of SQL code is designed to do$.$