Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Nested table or independent table

Nested table or independent table

From: Prasath <prasath.rao_at_gmail.com>
Date: 1 Feb 2006 02:45:25 -0800
Message-ID: <1138790725.084304.299890@z14g2000cwz.googlegroups.com>


I want to implement a simple employee, department relationship. Only condition is that an employee can belong to multiple departments.

Do I go for

  1. a three table implementation ( employee, department and employee_department ) or
  2. two table implementation( department and employee ) with employee table having a column which is a nested table of department ids ?

Also please let us know the advantages/disadvantages of each implementation?

Thanks,
Prasath. Received on Wed Feb 01 2006 - 04:45:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US