Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    5

    Unanswered: ERD's and Server Model Diagrams

    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

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: ERD's and Server Model Diagrams

    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));

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •