interview questions on erwin data modeler

#Interview questions on erwin data modeler how to#

Double click on that relationship line to open “Relationships wizard” and change the option from “Nulls Allowed” to “No Nulls” since bank should have a country code. Now you can see the relationship(a line drawn from Bank to Country) between “Country” and “Bank”. (c) Place the cursor on the entity “Bank”. (b) Place the cursor on the entity “Country”. (a) Click the symbol “Non Identifying Relationship”. To create a Foreign Key relationship, follow these steps. Click ok, and now you will be having 2 attributes Country Code, and Country Name under the entity “Country” in the current logical workplace.Ħ: Create another entity “Bank” with two attributes namely Bank Code and Bank Name by following steps 4 and 5.ħ: In order to relate these two tables country, bank, a Foreign Key relationship must be created.

Follow the same approach and create another attribute “Country Name” without selecting the primary key option. Select the option Primary Key to identify attribute “Country Code” as the primary key. Select the data type as “String” and click OK. Click “New” button on the wizard and type attribute name as “Country Code”. From the displayed menu, click attributes which will take you to the attribute wizard. Change it to “Country”.ĥ: To create an Attribute, Place the cursor on the entity “Country” and right click it. By default E/1 will be displayed as the entity name. Click Ok.Ĥ: To create an Entity, click the icon “Entity” and drop it on the workplace. The overarching goal of the data modeler role is to design and construct databases that enable organizations to access and utilize. Data modeling produces usable computer systems from complex business data at its core 1. Select the option “Logical/Physical” from the displayed wizard. Data modeling is the process by which data is evaluated, organized, measured, and managed in particular business processes. By default, logical will be your workplace.ģ: Click New from File menu. In the following section, a simple example with a step by step procedure to create a logical data model with two entities and their relationship are explained in detail.ġ: Open All Fusion Erwin Data Modeler software.Ģ: Select the view as “Logical” from the drop-down list.

#Interview questions on erwin data modeler how to#

How to create a Logical Data Model using Erwin 4.1.4 version?