Database Relation Help

[ahmed]

My database course just started , and i think that i am weak at finding out the relationships from a given statement , and also the number of tables that are to be made , so is there any tutorial or a book to help me understand that thing?

[bigz008]

i'm going to let you in on a little secret. Type---> ?intitle:index.of? Name of Book <------Into the google search engine, and you will find a bunch of books which you can download as pdf etc. You can also use this trick for downloading songs etc. So type names like database relations etc, or the name of a really good book you know for beginners etc...

[gokuajmes]

Please go through these tuts ,these are the best that any noob can go through

http://www.functionx.com/sqlserver/

[Jaan]

SQL Tutorial

this may help you maybe.. im not sure

[ahmed]

thanks for all the post but i think you people are not getting what i asked , i want some tutorial in which their are given examples on how to FIGURE out TABLES ENTITIES and ATTRIBUTES from a given statement

[WingedPanther]

There probably isn't such a tutorial, though I talked about it in one of my "building a big project" tutorials in the php section. It's very similar to how you figure out what types of variables to use to store data in a program. There isn't a hard guideline/procedure, just a general sense of "this is how the data exists".

It's similar to designing classes for an OOP solution, only you don't have to worry very much about class methods, just data. Each record in your database will be an "object".

[ahmed]

thanks again , i have a little question that i need to develop a relationship. I am a bit confused
A university has teachers,students and class rooms . A teacher can teach many courses , A student can study many courses , and a class room can have many classes . I have just studied how to use a primary key as a foreign key in another table , but i tried it but got stuck up . Question is that , can a composite key if i make in a table be used as a foreign key in another table , if so then how to do that?


I am only having problem with the students can study many courses , where courses is already linked with the teacher table

[WingedPanther]

You have another object: class. It has a teacher, a class room, and several students.