ERD ,Relation and SQL Simple Example to explain what is ERD

Question

Hello Guys

Please helpe to eplain more what is ERD and how can i put relationship into ERD and how can i write the script of SQL  or convert this ERD to SQL .

Thanks