or 02-9262-7770 
| An Introduction to Databases | |
By Chris Smith |
Published
12/13/2005
|
Programming
|
Rating:
 
|
|
|
Introduction to Database Design - Step 3So now our table will have this information: - newsid (our primary key) - title - content - author - approved - category Going through the same process for categories we end up with: - categoryid (our primary key) - categoryname - parentcategory Our authors table structure looks like: - authorid (our primary key) - author's name - author's email address - author's website url Our comments table structure looks like: - commentid (our primary key) - newsitem - subject - comment - author Looking at this graphically, we end up with something like this:  So we can see how everything links together (this is called a "relational database" since there are relationships between each of the tables). As you can see, there is quite a lot to properly designing a database, and we haven't even started creating any tables yet! |
|
Spread The Word
Article Series
This article is part 1 of a 4 part series. Other articles in this series are shown below:
-
An Introduction to Databases
Related Articles
9 Responses to "An Introduction to Databases" 
|
said this on 03 Jan 2006 10:16:44 AM CDT
Wonderful article. Very simplified. Would you know of any table templates for the most common database driven websites with welcome content, services and prices, contact information, and about us
|
Author/Admin)|
said this on 04 Jan 2006 12:19:46 AM CDT
Hi Nick,
Thanks for your comments! I don't know of any generic templates to use for a cms, they are all different unfortunately. Each one will have a different idea on how to do things so each database table will be slightly different. |
|
said this on 11 Jan 2006 7:58:31 PM CDT
How do you get printer version friendly format of the entire article?
[ Our response: Please click on the 'printer version' link underneath the title of the article. This was added just recently. ] |
|
said this on 09 Mar 2006 4:11:30 AM CDT
Hi, "awesome" info. Thank you.
|
|
said this on 15 May 2006 5:52:55 PM CDT
Have been trying to learn forever it seems. This is written wonderfully so that even a dummy SR SR (lol) on data base can understand. Thank you very much for you time in doing this and sharing it. Now you just need to put it in a vedio and sell it!!! I looked all over. nothing out there that is easy for someone like me to grasp!
|
|
said this on 15 May 2006 5:54:11 PM CDT
Have been trying to learn forever it seems. This is written wonderfully so that even a dummy SR SR (lol) on database can understand. Thank you very much for your time in doing this and sharing it. Now you just need to put it in a vedio and sell it! I looked all over. nothing out there that is easy for someone like me to grasp!
|
|
said this on 03 Dec 2006 12:41:50 AM CDT
It is very good article.
|
