Please convert the following ER Diagram to Sql satements

Use this template to create the sql statements

CREATE TABLE TableName

( AttributeName DataType NOT NULL DEFAULT ,

CONSTRAINT PrimaryKeyConstraintName PRIMARY KEY (AttributeName which is primary key),

CONSTRAINT ForeignKeyConstraintName

FOREIGN KEY ( AttributeName which is foreign key )

);

Please use whatever datatype you feel thats appropriate but if possible stick with number, int, char, varchar2 and date

Here is the Member table that ive already created, please follow closely to this format.

CREATE TABLE Member

( Member_ID INT , FirstName VARCHAR2(50) NOT NULL , LastName VARCHAR2(50) NOT NULL , DOB DATE NOT NULL , Gender CHAR(10) NOT NULL , Address VARCHAR2(100) NOT NULL , Mobile VARCHAR2(10), HomePhone VARCHAR2(10), Email VARCHAR2(50) NOT NULL , HealthCondition VARCHAR2(50) NOT NULL , EContactName VARCHAR2(50) NOT NULL , EContactMobile VARCHAR2(50) NOT NULL , EContactRelationship VARCHAR2(50) NOT NULL , AttendanceStatus CHAR(1), ParticipationStatus CHAR(1),

CONSTRAINT PK_Member_Member_ID PRIMARY KEY (Member_ID)

);

Membership ID Voting Right Ewents Attendance Event Attendance ID Member Membership Class Approved by Exercise Location Member ID Member ID Event D Membership Duration Event ID Event Name Event Date Family Acknowledgement Name Family Acknowledgement Stalus Family Acknowledgement Signature Event Photo Location Health Condition Emergency Contact Event Organiser History Family Acknowedgement Date Event Organiser ID K Member ID FM Event ID Emergency Contact Family Acknowledgement Relationship Emergency Contact Relationship Membership History Membership_History ParticipationStatus FK Member ID Mambership iD Course Couple Discoun Committee Member History Course ItD Committee Member Excercise Type Course Location Payment Payment ID Membarship History FK Member ID ype ID Training Assignment Member JD AttendanceDate Tim FK Trainer ID Committee Member Type Payment Date Payment Terms Payment Status Account S BarCode Committee Member Type ID tabus