Welcome Guest ( Log In | Register )



 
 Reply to this topicStart new topic
> How To Understand A Database Schema, A very nice and simple tutorial
TavoxPeru
post Sep 17 2008, 01:57 AM
Post #1


Super Member
Group Icon

Group: [HOSTED]
Posts: 794
Joined: 8-April 06
From: Lima - Peru
Member No.: 12,579
myCENTs:78.07
Yesterday while i'm seaching for a data model and database schema at the Library of Free Data Models for a new project of a friend of mine i found there this nice and simple tutorial on How to Understand a Database Schema.

As its name says, this tutorial will help you to better understand a Database Schema and covers the following basics topics that every Database Schema must define:
QUOTE
  1. Primary and Foreign Keys.
  2. One-to-Many and Many-to-Many Relationships.
  3. Inheritance.
  4. "Rabbit's Ears", (Recursive relationships).

The Scope of this tutorial is the process of buying on Starbucks and Amazon.com, covering Customers, Deliveries, Orders, Products and Suppliers and how they are related.

I think that this simple tutorial on How to Understand a Database Schema will be very helpful to everybody not only to newbies on this topic.

Best regards,
Go to the top of the page
 
+Quote Post
faulty.lee
post Sep 17 2008, 02:33 AM
Post #2


Super Member
Group Icon

Group: [HOSTED]
Posts: 500
Joined: 5-November 06
Member No.: 17,016
myCENTs:NEGATIVE[-20.12]
Sounds interesting, even though I've been using database for quite a few years already, but there always something new to learn. I've downloading the video now. Let see what's did I miss.
Go to the top of the page
 
+Quote Post
yordan
post Sep 17 2008, 09:00 AM
Post #3


Way Out Of Control - You need a life :)
Group Icon

Group: [MODERATOR]
Posts: 2,183
Joined: 16-August 05
Member No.: 7,896
myCENTs:15.50
Nice tutorial, you are right, thanks for the info.
The author is fantastic. I love his KISS concept.
QUOTE
Our motto - Keep It Simple and Straightforward (KISS)
Go to the top of the page
 
+Quote Post
jlhaslip
post Sep 23 2008, 11:47 PM
Post #4


Advanced Member
Group Icon

Group: Members
Posts: 189
Joined: 15-November 05
From: Inland from the Left Coast of Canada
Member No.: 9,627
myCENTs:62.43
KISS = Keep it Simple, Stupid...
Go to the top of the page
 
+Quote Post
Jezstarr
post Sep 29 2008, 04:31 PM
Post #5


Member [ Level 2 ]
Group Icon

Group: [HOSTED]
Posts: 63
Joined: 29-September 08
From: Australia
Member No.: 32,962
myCENTs:26.03
QUOTE(jlhaslip @ Sep 24 2008, 09:47 AM) *
KISS = Keep it Simple, Stupid...

That's what my teacher taught me, haha...well its a good tutorial, explains some good points.
Go to the top of the page
 
+Quote Post
« Next Oldest · Databases · Next Newest »
 

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. phpBB Database Transfer(10)
  2. Embedded Database(7)
  3. Need Advice On Creating Online Music Database(6)
  4. Mirror My MySQL Database To Another Mysql Server(4)
  5. The Best Database(48)
  6. Database Program With GUI(14)
  7. MySQL Output Database Question(18)
  8. What Is A Database How Do I Use One?(7)
  9. What Is Maximum Capacity Of Astahost MySQL Database?(11)
  10. Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database(4)
  11. Permission Problem With Mysql Database Creation(8)
  12. Need Info On Database Programming Courses(2)
  13. Database Programming In Vba 6.0(1)
  14. How Many Concurrent Users For Oracle Database?(1)
  15. Database Size?(10)
  1. My Sql Database Help?(3)
  2. Need Help In Database Auto_increment(9)
  3. Connecting To A Remote Database(9)
  4. Database(1)
  5. Integrate Access Database Onto Intranet Site(5)
  6. Accessing Ms Access Database From A Centralized Location?(5)
  7. Mysql Database Management(1)
  8. Mysql Database Entry By Excel Sheets(2)
  9. Space Needed For Database(10)
  10. Database Access On Remote Server W/jsp(0)
  11. Some Useful Database Links.(7)
  12. Best Database(13)
  13. Free Or Opensource Database/schema Browser?(6)


 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

- Lo-Fi Version Time is now: 20th November 2008 - 10:34 PM
Powered By IP.Board 2.2.1 © 2008  IPS, Inc.
Licensed to: Xisto Corporation