Table alias - simple question?

[Destramic]

Hey guys I have a quick question i've made a table alias below but what do you call it when you put the table alias front of the column names?...SELECT n.news FROM news n 

[mikosiko]

you can call it "alias" too if you want...

 

... but technically speaking,  table name, alias, and others objects names are known as identifiers

 

http://dev.mysql.com/doc/refman/5.5/en/identifiers.html

[Destramic]

exellect mikosiko, just what i needed...also another thing if you have 3 tables they'd be called

 

table 1 = table

table 2 = relationship table

table 3 = ?

 

if you could help please...thank again for your help

[mikosiko]

if you have 3 tables they'd be called

 

table 1 = table

table 2 = relationship table

table 3 = ?

 

the short answer... very..very simplified... everyone is called just "table" ... but topic is more complex than that, therefore the question hasn't a short answer ... literally we can write a book ... but is a lot out there already (Data Modeling, Database Modeling, Database Design, etc.)

 

here are some articles (from 1000's out there) that could give you guidance if you want to learn

http://www.agiledata.org/essays/dataModeling101.html#IdentifyDataEntities

http://www.sqlteam.com/article/database-design-and-modeling-fundamentals

 

this is a good paper too that cover a lot of concepts

http://www.eecs.umich.edu/~teorey/lec.notes.pdf

[Destramic]

i've had a read...and alot seems a bit complex but i couldnt find the part where it labels table two and three in a relationship...if you could help me please

[mikosiko]

I said:

the short answer... very..very simplified... everyone is called just "table"

(even when the term is not exactly correct.. it is accepted)

 

but... maybe I didn't understand your question...  if so.. clarify your question further

 

this is a other good source for you to learn concepts/terminology if you want to read it

http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch01.pdf on it the chapter about SETS, TABLES, RELATIONS and Databases should give you better answers.