Home » RDBMS Server » Server Administration » DB´s Models...
DB´s Models... [message #373813] Mon, 14 May 2001 08:27
Otávio
Messages: 6
Registered: April 2001
Junior Member
Hello there,

What´s the better Relation´s Modeling?

1)

|¯¯¯¯¯¯¯¯¯|
|Master_id| record id used like key in relation rules.
|---------|
|pkfield1 |\
|pkfield2 |--> Unique index... (simulating primary key)
|pkfield3 |/
|field1 |
|fieldn |
¯¯¯¯|¯¯¯¯
|
/|\
|¯¯¯¯¯¯¯¯¯|
|Detail_id|
|---------|
|Mater_Id |--> Foreign Key
|field1 |
|fieldn |
¯¯¯¯¯¯¯¯¯

2)

|¯¯¯¯¯¯¯¯¯|
|pkfield1 |\
|pkfield2 |--> primary key
|pkfield3 |/
|---------|
|field1 |
|fieldn |
¯¯¯¯|¯¯¯¯
|
/|\
|¯¯¯¯¯¯¯¯¯|
|Detail_id|
|---------|
|fkfield1 |\
|fkfield2 |--> Foreign Key
|fkfield3 |/
|field1 |
|fieldn |
¯¯¯¯¯¯¯¯¯

thanks so much...

Otávio

Report message to a moderator

Previous Topic: Plzz help me to find out this problem with procedure
Next Topic: how to insert gif image into table?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 04:26:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.