CODEWITHSUNDEEP
sqldatabase-designdata-modelingforeign-key-relationship
Dmitry Makovetskiyd
Dmitry Makovetskiyd

Reputation: 7053

Asp.net database table relationships

I am looking at a way to establish a few tables in my database.

I want to connect every user that logs in to the comments that they leave. There should be 2 or 3 tables. But I have no understanding on how to achieve this. Does anyone know where I can read and learn about how to build table relationships effectively?

Upvotes: 0

Views: 1785

Answers (2)

Don
Don

Reputation: 171

You should understand how 'joins' work. They will define how you access your data later.

Check out this site: http://www.sql-tutorial.net/SQL-JOIN.asp

Even if you don't have MS Access, this is a good tutorial for getting a handle on creating tables and defining relationships.

http://office.microsoft.com/en-us/training/design-tables-for-a-new-access-2007-database-RZ010286445.aspx

Also, "SQL for Dummies" is a great reference to have. Get a used copy on Amazon.

Upvotes: 2

Joel Beckham
Joel Beckham

Reputation: 18664

Here's a walk-through for SQL Server 2005: http://dotnetguts.blogspot.com/2007/10/basics-of-sql-server-2005.html

Upvotes: 1

Related Questions