Re: Resiliency To New Data Requirements

After implementing the prior solutions, we find we need to store each department's attributes thus requiring a separate table.

RMDB:
CREATE TABLE dept (deptID, name, ...);

INSERT INTO dept (1, finance);
INSERT INTO dept (2, safety);
INSERT INTO dept (3, personnel);
INSERT INTO dept (4, marketing);

Update Query:
SELECT employee.*
FROM (employee INNER JOIN employee_dept ON employee.empID = employee_dept.empID) INNER JOIN dept ON employee_dept.deptID = dept.deptID
WHERE (((dept.name)="safety") AND ((employee.salary)=20000));

DBD:
No change. Original query still ok, returns Mary. (and (select employee instance *)

(select * dept safety)
(select * salary 20000))
Received on Wed Aug 02 2006 - 23:48:15 CEST