Logical Data Modeling
- Identify major entities
- Determine relationships between entities
- Determine primary and alternate keys
- Determine foreign keys
- Determine key business rules
- Add remaining attributes
- Validate user views through normalization
- Determine domains
- Determine triggering operations
- Combine user views
- Integrate with existing data models
- Analyze for stability and growth
Translate Logical Model into the Real Database System
- Identify tables
- Identify columns
- Adapt data structure to product environment
- Design for business rules about entities
- Design for business rules about relationships
- Design for additional business rules about attributes
- Tune for scan efficiency
- Define clustering sequences
- Define hash keys
- Add indexes
- Add duplicate data
- Redefine columns
- Redefine tables
Design for Special Design Challenges
- Provide for access through views
- Establish security
- Cope with very large databases
- Access and accommodate change
- Anticipate relational technology evolution
Reference: C. C. Fleming and B. V. Halle
From: http://sitestree.com/?p=4896
Categories:6
Tags:
Post Data:2011-01-04 05:33:34
Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
(Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a>
In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
<a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
