{"id":69017,"date":"2021-08-10T04:10:05","date_gmt":"2021-08-10T08:10:05","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/logical-data-modeling-logical-database-design-steps-rdbms-6\/"},"modified":"2021-08-10T04:10:05","modified_gmt":"2021-08-10T08:10:05","slug":"logical-data-modeling-logical-database-design-steps-rdbms-6","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=69017","title":{"rendered":"Logical Data Modeling: Logical Database Design Steps: RDBMS #6"},"content":{"rendered":"

Logical Data Modeling<\/b> <\/p>\n

    \n
  1. Identify major entities <\/li>\n
  2. Determine relationships between entities <\/li>\n
  3. Determine primary and alternate keys <\/li>\n
  4. Determine foreign keys <\/li>\n
  5. Determine key business rules <\/li>\n
  6. Add remaining attributes <\/li>\n
  7. Validate user views through normalization <\/li>\n
  8. Determine domains <\/li>\n
  9. Determine triggering operations <\/li>\n
  10. Combine user views <\/li>\n
  11. Integrate with existing data models <\/li>\n
  12. Analyze for stability and growth <\/li>\n<\/ol>\n

    Translate Logical Model into the Real Database System<\/b><\/p>\n

      \n
    1. Identify tables <\/li>\n
    2. Identify columns <\/li>\n
    3. Adapt data structure to product environment <\/li>\n
    4. Design for business rules about entities <\/li>\n
    5. Design for business rules about relationships <\/li>\n
    6. Design for additional business rules about attributes <\/li>\n
    7. Tune for scan efficiency <\/li>\n
    8. Define clustering sequences <\/li>\n
    9. Define hash keys <\/li>\n
    10. Add indexes <\/li>\n
    11. Add duplicate data <\/li>\n
    12. Redefine columns <\/li>\n
    13. Redefine tables<\/li>\n<\/ol>\n

      Design for Special Design Challenges<\/b><\/p>\n

        \n
      1. Provide for access through views <\/li>\n
      2. Establish security <\/li>\n
      3. Cope with very large databases <\/li>\n
      4. Access and accommodate change <\/li>\n
      5. Anticipate relational technology evolution<\/li>\n<\/ol>\n

        Reference: C. C. Fleming and B. V. Halle<\/p>\n

        From: http:\/\/sitestree.com\/?p=4896
        Categories:6
        Tags:
        Post Data:2011-01-04 05:33:34<\/p>\n

            Shop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a>\n    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"> http:\/\/Training.SitesTree.com<\/a> \n    In Bengali: <a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\">http:\/\/Bangla.SaLearningSchool.com<\/a>\n    <a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\">http:\/\/SitesTree.com<\/a>\n    8112223 Canada Inc.\/JustEtc: <a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\">http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a>\n    Shop Online: <a href='https:\/\/www.ShopForSoul.com'> https:\/\/www.ShopForSoul.com\/<\/a>\n    Medium: <a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"> https:\/\/medium.com\/@SayedAhmedCanada <\/a>\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
        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 … <\/p>\n
        Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-69017","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":24400,"url":"http:\/\/bangla.sitestree.com\/?p=24400","url_meta":{"origin":69017,"position":0},"title":"Overview on .Net Solution Architecture #Root","author":"Author-Check- Article-or-Video","date":"April 8, 2021","format":false,"excerpt":"Overview on .Net Solution Architecture Actually, I wrote this long back as you can see at: http:\/\/salearningschool.com\/displayArticle.phptable=Articles&articleID=793&title=Overview%20on%20.Net%20Solution%20Architecture Microsoft Solution Framework is a combination\/mix of both Waterfall model and Spiral model. It includes waterfall models milestone based planning and resulting predictability with the spiral model's benefits of feedback and creativity Roles\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69408,"url":"http:\/\/bangla.sitestree.com\/?p=69408","url_meta":{"origin":69017,"position":1},"title":"Overview on .Net Solution Architecture #20","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"Just an overview (Will be updated ...). Microsoft Solution Framework is a combination\/mix of both Waterfall model and Spiral model. It includes waterfall models milestone based planning and resulting predictability with the spiral model's benefits of feedback and creativity Roles in the MSF Team Model: Product Management (Deals with customers,\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22045,"url":"http:\/\/bangla.sitestree.com\/?p=22045","url_meta":{"origin":69017,"position":2},"title":"Skills required for an Advanced Database Designer\/Architect role (or for a data modeler role) #Software Development #Web Development #Root #Miscellaneous #By Sayed Ahmed","author":"Author-Check- Article-or-Video","date":"March 9, 2021","format":false,"excerpt":"ER Studio ERWin Powerdesigner DbVisualizer star-schemas snow-flake 3NF relational models logical modeling enterprise database design From: http:\/\/sitestree.com\/?p=357 Categories:Software Development, Web Development, Root, Miscellaneous, By Sayed AhmedTags: Post Data:2013-08-30 00:07:09 Shop Online: https:\/\/www.ShopForSoul.com\/ (Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com In Bengali: http:\/\/Bangla.SaLearningSchool.com http:\/\/SitesTree.com 8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning)\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":70215,"url":"http:\/\/bangla.sitestree.com\/?p=70215","url_meta":{"origin":69017,"position":3},"title":"Must Read: Database Driven Software Development #106","author":"Author-Check- Article-or-Video","date":"August 29, 2021","format":false,"excerpt":"If you are developing database driven applications, you must need to know and clearly understand the following concepts. Yes, you also need to apply them in your design and implementation. If you do not follow proper database design strategies, many complexities will arise, adjusting new requirements may become cumbersome to\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22581,"url":"http:\/\/bangla.sitestree.com\/?p=22581","url_meta":{"origin":69017,"position":4},"title":"Logical Design for Data Warehouse #Root #By Sayed Ahmed #Data Warehouse – 001 #Data Warehouse #Data Warehouse Misc","author":"Author-Check- Article-or-Video","date":"March 16, 2021","format":false,"excerpt":"Logical Design for Data Warehouse \u00a0 \u00a0 [youtube https:\/\/www.youtube.com\/watch?v=0MFBP14FCqQ] From: http:\/\/sitestree.com\/?p=1931 Categories:Root, By Sayed Ahmed, Data Warehouse - 001, Data Warehouse, Data Warehouse MiscTags: Post Data:2015-02-24 21:18:26 Shop Online: https:\/\/www.ShopForSoul.com\/ (Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com In Bengali: http:\/\/Bangla.SaLearningSchool.com http:\/\/SitesTree.com 8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) Shop Online:\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27125,"url":"http:\/\/bangla.sitestree.com\/?p=27125","url_meta":{"origin":69017,"position":5},"title":"FilterExample.jsp Page that uses the FilterTag custom tag #Programming Code Examples #Java\/J2EE\/J2ME #Applets and Basic Graphics","author":"Author-Check- Article-or-Video","date":"May 11, 2021","format":false,"excerpt":"FilterExample.jsp Page that uses the FilterTag custom tag     HTML Logical Character Styles<\/TITLE> <LINK\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69017","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=69017"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69017\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69017"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}