>>Previous>>

Dimensional Data Model:

» Is there any specific notation to identify a Data Warehouse/Data mart data models?

Subject Area:

» How to create subject area and assign relevant entities to subject area?

Reports:

» How to generate reports from data model and export to .XLS, .DOC, .XML file formats?

Naming Options:

» Is there any method to change the entity/table, attribute/column name from upper case to
lower case or lower case to upper case?

Import & Export:

» How to create data models from .xls, .txt files etc.?

» How to import and export meta data into ETL tools?

Abbreviation Document:

» How to create/attach a standard abbreviation document(for naming tables, columns etc.)?

Print:

» How to send data models to printer/plotter/Acrobat Reader?

Backup:

» How to take backup of data model?

Others:

» How to split a data model to logical and physical data model?

» How to copy and paste objects within data model and across data models?

» How to search an object within a data model?

» How to change the font size and color of entities,attributes,relationship lines?

» How to create a legend?

» How to show a data model in different levels like entity level, attribute level, and definition
level?

>>>Next>>>

Data Modeling Tools: What to Learn?

Data modeling tools are the only way through which we can create powerful data models. Following are the various options that we have to know and learn in data modeling tools before start building data models.

Software:
» How to install the data modeling tool on server/client?

Logical Data Model:

» How to create entity and add definition, business rule?
» How to create domains?
» How to create an attribute and add definition, business rule, validation rules like default values and check constraint?
» How to create supertypes, subtypes?
» How to create primary keys, unique constraint, foreign key relationships, and recursive relationships?

» How to create identifying and non-identifying relationship?

» How to assign relationship cardinality?

» How to phrase relationship connecting two tables?

» How to assign role names?

» How to create key groups?

» How to create sequence no's?

Physical Data Model:

» How to rename a table?

» How to rename a column,validation rules like default and check constraints?

» How to assign NULL and NOT NULL to columns?

» How to name foreign key constraints?

» How to connect to databases like MS Access, Oracle, Sibase, Terradata etc?

» How to generate sql code from data model to run against databases like MS Access, Oracle, Sibase, Terradata etc.?

» How to create a data model from an existing database like MS Access, Oracle, Sibase, Terradata etc.?

» How to add database related properties to tables, indexes?

» How to check different versions of the data model?

» How many data modelers can concurrently work on the same version of a data model?

>>Previous>>

Data Modeling Tools


There are a number of data modeling tools to transform business requirements into logical data model, and logical data model to physical data model. From physical data model, these tools can be instructed to generate sql code for creating database.




Popular Data Modeling Tools

Tool Name	Company Name
Erwin	Computer Associates
Embarcadero	Embarcadero Technologies
Rational Rose	IBM Corporation
Power Designer	Sybase Corporation
Oracle Designer	Oracle Corporation
Xcase	RESolution LTD.

>>>Privious>>>