Also a lot in the left pane tree changes. Select 'Physical' from the drop down at the top/center of the window.We are ready to convert into a physical model and create the tables in the database. Ensure 'NONE' is selected in all the six dropdowns in this tab, under the subheading 'RI Actions'Īt this stage we have created a simple Logical model.Double click on the relationship line/icon and select the 'RI Actions' tab.This step has created a Zero-or-One-to-Zero-One-or-More relationship between the Department and Employee entities.Observe it will add the letters (FK) in the Employee entity for the DepartmentId attribute

Just click 'Ok' on the ensuing popup, which says the name already exists.Click on 'Non Identifying Relationship' and first click on the department.Click on 'New' and enter 'DepartmentName' without the quotes for the 'Column Name:' and 'Attribute Name:' textbox.Enter 'Department' without the quotes for the 'Name:' textbox and click OK.Click on 'New' and enter 'DepartmentId' without the quotes for the 'Column Name:' and 'Attribute Name:' textbox.You can change the datatypes here, but for now this is fine. In the 'Datatype' tab observe that Erwin has defined the datatype as varchar(20).Click on 'New' and enter 'EmployeeName' without the quotes for the 'Column Name:' and 'Attribute Name:' textbox.In the 'General' tab select the 'Primary key' checkbox.Click on 'New' and enter 'EmployeeId' without the quotes for the 'Column Name:' and 'Attribute Name:' textbox.Right click on the icon again and this time select 'Attributes.'.Enter 'Employee' without the quotes for the 'Name:' textbox and click OK.Right click on the entity icon and select 'Entity Properties.'.Click on Entity and click on a clean area in the designer.Select View -> Toolbar and ensure all options are selected.Ensure you have 'SQL Server 2000' selected.Select the Logical/Physical radio button and click OK.Model, while keeping in mind the real world Data Modeling scenarios.Įnvironment: I tested all this on SQL Server 2000 and Erwin Data Modeler r7 It is a step by step example showing how to create a simple Data Powerful industry standard Data Modeling tools, ERWIN. In this write up I will try to demonstrate how to use one of the very Data Modeling using ERWIN and SQL Server 2000

Allfusion erwin data modeler r7.2