|
Data Modeling Overview Tutorial |
|
Before we start learning Oracle , it's very important that you understand the Relational Database Concepts and Data Modeling concepts. Please go through this very good tutorial to get an overview. Data Modeling Overview: A data model is a plan for building a database. To be effective, it must be simple enough to communicate to the end user the data structure required by the database
yet detailed enough for the database design to use to create the physical structure. A data model is a conceptual representation 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. As the name implies, 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. To use a common analogy, the data model is equivalent to an architect's building plans.
A data model is independent of hardware or software constraints. Rather than try to represent the data as a database would see it, the data model focuses on representing the data as the user sees it in the "real world". It serves as a bridge between the concepts that make up real-world events and processes and the physical representation of those concepts in a database.
Data Modeling
Overview
E-R Model
Database Design
Data Objects
Basic Schema
Refining the E-R
Primary Keys
Attributes
Hierarchies
Integrity Rules
Bibliography
Trackback(0)
 |
TrackBack URI for this entry
Subscribe to this comment's feed
Show/Hide comments
Show/Hide comment form
