I am very much a beginner and taking a class on databases. My assignment involves using Crow's Foot notation to represent the following tables: This is my design for it so far. I am nowhere near done but am I at least on the right track? I would have to use a composite entity to resolve the M:N relationships shown with these tables, right? (Those M:N relationships being Employee to Plan and Benefit to Plan) Please be forgiving of my work haha. I really appreciate all of the help and insight! Hope you all have a good one wherever you are!

Thats the ERD. I'm studying for an upcoming test and having trouble getting my head around converting this ERD into dependency diagrams. This is from a previous exam that the Lecturer told us to study just btw so he said it will be pretty similar to this. We have to - - Convert the ERD into a dependency diagram. - And then, convert that diagram into a 3NF model, with no transitive or partial dependencies. Any help would be much appreciated as I'm struggling to get my head around it and need to pass this test :/ Thanks in advance!

We have upgraded to SQL 2012 and Am trying to reverse engineer our Dbs into Visio 2010. I setup a connecting using SQL 11 driver and Visio complains that that driver is not supported. Any one run into this?

I am using Visio 2010 to create a ER diagram. When I insert the column names, I can't find timestamp or rowversion data types. Is there an alternative?

I have a database diagram that I would like to extract from SQL and manipulate it to create a user-friendly and easier-on-the-eye ERD. The database contains over 200 tables and I would like to map the tables out to show other how it works to others. I don't want to reverse engineer as Visio reformats the ERD and no longer looks like the model I have in database designs. I'm aware that you can right-click and copy-to-clipboard however this captures the model as an image which means I can't manipulate it. Is there an alternative piece of software out there that I'm not aware of?

I have an Oracle database, and I would like to create an ERD in Visio 2007 Pro. I have so far looked at DBMS_METADATA.GET_DDL commands to generate DDL. I know that I can import an Access DB into Visio, but it seems that Access understands an SQL dialect which is different from Oracle, so I would need to tweak every Create Table command to change the data types. Is there a simple way to create an ERD using DDL in Visio Pro 2007?

I have the following Create table statement from SQL Developer and I am trying to generate an ERD Diagram using 2003 Visio. I was wondering what I need to do to convert the Create Table from SQL Developer to an ERD Diagram Using Visio. CREATE TABLE “TT_TEAM”.”HR_REVOKED_SECURITY_ORGS” ( “ID” NUMBER NOT NULL ENABLE, “ACAT_CODE” VARCHAR2(6 BYTE) NOT NULL ENABLE, “APPR_SEQ_NO” NUMBER(3,0) NOT NULL ENABLE, “USER_ID” VARCHAR2(30 BYTE) NOT NULL ENABLE, “ACTION_IND” VARCHAR2(1 BYTE) NOT NULL ENABLE, “ACTIVITY_DATE” DATE NOT NULL ENABLE, “COAS_CODE” VARCHAR2(1 BYTE), “ORGN_CODE” VARCHAR2(6 BYTE), “POSN” VARCHAR2(6 BYTE) NOT NULL ENABLE, “MANDATORY_APPR_IND” VARCHAR2(1 BYTE), “APPR_POSN” VARCHAR2(6 BYTE), “ORGN_MANAGER” VARCHAR2(6 BYTE) NOT NULL ENABLE;