want to learn database ?

Question

i am starting learn database, i have two options first access 2003 and second sql 205 which would be ideal for me to design my database my front hand will be vb 2005. specially it is too hard for me to understand relations between the two tables. any suggestions.

Answer 1

now from your point of view. you can choose access 2003 for few days as a starting and basic just to wash your hand with database. once you are familiar with database design like what is rows tables quaries relations etc. then u can jump upto sql. Sql is good specially when u r matching it with VB 2005. as a backhand.

Answer 2

First rule in database : take the redundancy out of the data.

instead making one table :
Table Book =
Author_Name
Address
Phone
City
Book_ID
Book_Title
Cost
Stock

it's better if we separated it to :
Table Book =
Book_ID,
Book_Title
Cost
Stock
*Author_ID

Table Author =
*Author_ID
Author_Name
Address
Phone
City

so in Book Table, we don't have to fill Author_Name, Address, Phone and City again.
the 'Connection' between Book Table and Author Table with *Author_ID , we call 'Relations'

try this site : http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html

Answer 3

search yahoo or google for database tutorial you find many sites which will give you better understanding o database

Answer 4

read any standard book of RDBMS..this will help u...once u have some dbms concepts it'll b easier for u to learn sql etc