construction of a database of bacterial genomic and protein sequences

Question

[Debut]

Hello, I am a beginner in bioinformatics. I am trying to build a database of bacterial genomes and protein sequences with SQL. I don't know if it's good or not, can you help me please? Should I add tables or should I delete some in your opinion? Thank you. Here is my code:

create table Genome ( 
ID interger NOT NULL AUTO_INCREMENT,
name varchar (300) NOT NULL,
sequence text,
numero_accesion text);

create table gene (
ID integer NOT NULL AUTO_INCREMENT,
name text,
sequence text
FOREIGN KEY (ID_genome) REFERENCES genome (ID));

create table proteine (
ID integer NOT NULL AUTO_INCREMENT,
name text,
sequence text
FOREIGN KEY (ID_gene) REFERENCES gene (ID));

create table Espece(
ID integer NOT NULL AUTO_INCREMENT PRIMARY KEY,
name_latin text,
FOREIGN KEY (ID_Genome) REFERENCES genome (ID));

[GenoMax]

Prior references:
construction of a database
how to implement a database with several FASTA files

[Debut]

thank you for your help, but I still can't find the answer

[lieven.sterck]

before continuing: the question is really to create a database in mysql?

you're thus not mixing this up with creating a "database" to be used in blast or such, right?

[Debut]

basically I have to make a graphical interface of a database. i.e. there will be a drop down list with the bacterial species. From that I can select the species. On this graphical interface also there will be a comparative analysis part (blast, alignment,..)

[Ram]

How much experience do you have building a GUI or a database? You seem to rely on external support for the most basic steps of your internship, how is that going to benefit your career?