Assignment 6 Now is the time to get into the heart of the Web Application you will need a DB Table to hold the Local Translator details along with another table to join that Translator to the Langauge table Something like: ------------------------------------------------------- CREATE TABLE TRANSLATOR ( ID INTEGER IDENTITY (1, 1), NAME VARCHAR(50) NOT NULL, EMAIL VARCHAR(50) NOT NULL, PHONE CHAR(20) NOT NULL, LOCATION VARCHAR(256) NOT NULL, UPDATED DATE NOT NULL, CONSTRAINT PK_TRANSLATOR PRIMARY KEY (ID) ); CREATE TABLE TRANSLATOR_LANGUAGE ( TRANSLATOR_ID INTEGER NOT NULL, LANGUAGE_CODE VARCHAR(3) NOT NULL, CONSTRAINT PK_TRANSLATORLANGUAGE PRIMARY KEY (TRANSLATOR_ID,LANGUAGE_CODE) ); ALTER TABLE TRANSLATOR_LANGUAGE ADD CONSTRAINT FK_TRANSLATOR_LANGUAGE_LANGUAGE FOREIGN KEY (LANGUAGE_CODE) REFERENCES LANGUAGE(CODE); ALTER TABLE TRANSLATOR_LANGUAGE ADD CONSTRAINT FK_TRANSLATOR_LANGUAGE_TRANSLATOR FOREIGN KEY (TRANSLATOR_ID) REFERENCES TRANSLATOR(ID); Next you will need a component with a form to enter records into the Database You will also need Entity class(es), Database interface and Repository entries