Efficient Databasing

[stuart7398]

Hi.

I am learning to understand MySql, and how to run an efficient Database.

 

Tell me if I am wrong, or on the right track?

 

I have a

Database,

Then I have a

Table within this Database.

This Database then Joins to other Tables with different Data, within the same Database.

 

OR

Do I set up individual Databases and link to these individual Databases to extract Data?

 

There will be 30 colunms with little data  such as 'name' 'location'

3 images

1 description area with around 300 words.

 

 

Your help is appreciated.

 

Thanks,

Stuart.

 

 

 

[fenway]

I don't understand.

[obsidian]

I think your choice of terms between "table" and "database" may not be clear. Typically speaking, a given application will be run from a single database with multiple tables. Your tables need to be normalized as much as possible, which will then require joining tables to gather your data.