Web laynetworks.com Home | Site Map | Tell a friends

Management Tutorials Download Tutorials History Computer Science Networking OS - Linux and Unix Source Code Script & Languages Protocols Glossary IGNOU Quiz About Us Contact Us Feedback   Sign up for our Email Newsletter   Get Paid for Your Tech Turorials / Tips Click Here   Home > Tutorial > Entity Relational Modeling vs. Dimensional Modeling > Steps to create a Data Model Page : 1 2 3 4 5 6 7 8 9 10 Entity Relational Modeling vs. Dimensional Modeling   Steps to create a Data Model   Get Business requirements. Create High Level Conceptual Data Model. Create Logical Data Model. Select target DBMS where data modeling tool creates the physical schema. Create domain. Create Entity and add definitions. Create attribute and add definitions. Assign datatype to attribute. If a domain is already present then the attribute should be attached to the domain. Create primary or unique keys to attribute. Create check constraint or default to attribute. Create unique index or bitmap index to attribute. Create foreign key relationship between entities. Create Physical Data Model. Add database properties to physical data model. Create SQL Scripts from Physical Data Model and forward that to DBA. Maintain Logical & Physical Data Model.   Page : 1 2 3 4 5 6 7 8 9 10

Donation | Useful links | Link to Laynetworks.com | Legal Copyright © 2000-2010 Lay Networks All rights reserved.