create database for the following schema, write code by using SQL code. (create table) insert records( values) into tables in this database using SQL code.(value insertion)

-explain the schema(primary key and foreign key etc)

-show the ER diagram of it

LECTURER SUBJECT LECTURER_ID LECTURER_NAME COURSE_ID SUBJECT_ID SUBJECT_NAME LECTURER_ID STUDENT STUDENT_ID STUDENT_NAME DOB DOOR # STREET CITY STATE PIN COURSE_ID COURSE COURSE_ID COURSE_NAME STUD_HOBBY STUDENT_ID HOBBY