OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » DB´s Models...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 10:35:59 CST 2024