Quote:
Originally posted by larryb
Why is it that when a ERD get passed thru the Database Design Transformer the resultant relational tables that are displayed on the Design Editor(Server Model,Relational Tabel Definition) have new attribute columns that I never included. They appear to be foreign key attributes, but I've already defined the attribute fields when I developed the ERD. Is there a way to stop this?
Thanks,
Larry
|
When using the ERD, you should not define attributes for foreign keys, just define the relationships. The transformer automatically creates the necessary columns in the tables.
Simple example ERD:
Dept( deptno(UID), dname ) --< Emp( empno(UID), ename )
== TRANSFORM ==>
Table DEPTS( deptno(PK), dname );
Table EMPS( empno(PK), ename, deptno(FK to DEPTS));