Data Modeling

Essay by tastycake20University, Master'sA, July 2009

download word file, 10 pages 0.0

Table of ContentsChapter 1Introduction…………………………………………………...3Chapter 2Data Mining Overview...……………………………………4-9Chapter 3 Purpose of Data Mining…….…………………………….10-11Chapter 4Conclusion………………………………………………..12-13Bibliography………………………………………………………………14Chapter 1IntroductionData modeling is an important skill for IT professionals including: database administrators, data modelers, business analysts and software developers. It is an essential ingredient of nearly all IT projects. Without a data model there is no blueprint for the design of the database.

Data modeling is the process of creating and extending data models which are visual representations of data and its organization. There are two major methodologies used to create a data model: the Entity-Relationship (ER) approach and the Object Model. The ERD Diagram or is the most popular type of data model. Data models exist at multiple levels including:•The Conceptual Data Model describes data from a high level. It defines the problem rather than the solution from the business point of view. It includes entities and their relationships. Typically the conceptual data model is developed first.

•The Logical Data Model describes a logical solution to a data project. It provides more details than the conceptual data model and is nearly ready for the creation of a database. These details include attributes, the individual pieces of information that will be included. Typically the logical data model is developed second.

•The Physical Data Model describes the implementation of data in a physical database. It is the blueprint for the database. Typically the physical data model is developed thirdChapter 2Data Modeling OverviewA data model is an abstract version of the data structures that are required by a database. The data structures include the data objects, the associations between data objects, and the rules which govern operations on the objects. The data model focuses on what data is required and how it should be organized rather than what operations will be performed on the data. A data model is...