Help creating a database.

[Worf]

Hi.

 

I don't know anything about Databases and i want to create a database to store the contents of text files and other information.

 

What it will hold:

 

Contents of text files.

Description of the text files

The usage of the text files.

Name of the text files.

 

So, i have a text file, the application reads the contents of the text file and stores that information in the database. The user will be able to type the description of what the text file is and also the usage and store this with the text file.

 

There will also be Catagories and Sub-Catagories which the text files will be stored under.

 

Example:

 

Catagory: FPI

Sub-Catagory: Enemies.

 

So, if the user selects FPI & Sub-Catagory Enemies, then the text file will be stored under this.

 

I have managed to use ArrayList to store the information but but not sure how to do it with Catagories and Sub-Catagories.

 

Many thanks for your help.

 

Regards

Worf