| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Data Redundancy
B Faux wrote:
>
> In my world (MV), you would have an employee file (table) with a department
> attribute (row) that allows for an unlimited number of departments. Then
> you would also have a department file that would allow for an unlimited
> number of employees.
Just out of curiosity, in which MV DBMSs would it be possible to specify a declarative integrity constraint that said that one relationship (emp->dept) is the inverse of the other relationship (dept->emp)? Or how else would you prevent inconsistency in your database?
![]() |
![]() |