Sign Up


Have an account? Sign In Now

Sign In


Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.


Have an account? Sign In Now

You must login to ask a question.


Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Sign InSign Up

eduhilfe

eduhilfe

eduhilfe Navigation

  • HOME
  • CONTACT
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • HOME
  • CONTACT
Home==> Questions==>Q 189
Next
In Process
sweta
  • 0
sweta
Asked: May 4, 20202020-05-04T14:30:09+01:00 2020-05-04T14:30:09+01:00In: Advance Management of Data(AMD)

Discuss why the weaknesses of the relational data model and relational DBMS may make them unsuitable for advanced database applications?

  • 0
Discuss why the weaknesses of the relational data model and relational DBMS may make them unsuitable for advanced database applications?
amd
  • 2 2 Answers
  • 94 Views
  • 0 Followers
  • 0
Share
  • Facebook

    Leave an answer
    Cancel reply

    You must login to add an answer.


    Forgot Password?

    Need An Account, Sign Up Here

    2 Answers

    • Voted
    • Oldest
    • Recent
    1. sweta
      2020-05-04T14:35:44+01:00Added an answer on May 4, 2020 at 2:35 pm
      This answer was edited.
      1. Poor representation of real-world entities –

      The process of deriving relations from a conceptual database often leads to the creation of relations that do not directly correspond to modeled entity types. Cause • complex entities consists of other entities • entities are described by multi-valued attributes Result • fragmentation of a entity type into many relations • is inefficient and leads to many joins during query processing 2. Semantic Overloading The relational model uses only one construct for representing data and relationships between data: the relation. There is no mechanism to distinguish between entities and relationships, or to distinguish between different kinds of relationship that exist between entities. Often, attributes of different entities are mixed within one relation. Considering only the given relation, we cannot know, which attributes belong to a certain entity or relationship. ➔ the relational model is said to be semantically overloaded 3. Poor support for integrity and general constraints Integrity refers to the validity and consistency of stored data. Integrity is usually expressed in terms of constraints, which are consistency rules that the database is not permitted to violate. Many commercial systems do not fully support these constraints and it is necessary to build them into the applications. This is dangerous and can lead to duplication of effort and inconsistencies. There is no support for general constraints in the relational model, which again means that they have to be built into the DBMS or the application. 4. Homogeneous data structure The relational model assumes both horizontal and vertical homogeneity. • Horizontal homogeneity means that each tuple of a relation must be composed of the same attributes • Vertical homogeneity means that the values in a particular column of a relation must all come from the same domain The first normal form requires that the intersection of a row and column must be an atomic value. Drawbacks of Homogeneity • too restrictive for many (more complex) “real-world” objects • leads to unnatural and inefficient joins. 5. Limited Operations The relational model has only a fixed set of operations, such as set and tuple-oriented operations, operations that are provided in the SQL specification. Since (at least older versions of) SQL is not computationally complete, new operations cannot be specified. This is too restrictive to model the behavior of many real-world objects. 6. Difficulty handling recursive queries Atomicity of data means that repeating groups are not allowed in the relational model. As a result, it is extremely difficult to handle recursive queries, that is, queries about relationships that a relation has with itself (directly or indirectly). 7. Impedance Mismatch Older versions of SQL lack computational completeness and could not be used to develop more complex database applications. To overcome this problem, SQL can be embedded in a procedural programming language. However, this approach produces an impedance mismatch, because different programming paradigms are mixed: • SQL is a declarative language that handles many rows of data at a time • common high-level languages (such as C) are procedural languages that can handle only one row of data at a time Since the type systems are different, type checking is prevented and necessary conversions require a lot of programming effort and runtime resources.  

      • 0
      • Reply
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
        • Share on WhatsApp
    2. sweta
      2020-05-04T14:40:40+01:00Added an answer on May 4, 2020 at 2:40 pm

      1. Poor representation of real-world entities —

      The process of deriving relations from a conceptual database often leads to the creation of relations that do not directly correspond to modeled entity types.
      Cause
      • complex entities consists of other entities
      • entities are described by multi-valued attributes
      Result
      • fragmentation of a entity type into many relations
      • is inefficient and leads to many joins during query processing
      2. Semantic Overloading–
      The relational model uses only one construct for representing data and relationships between data: the relation.
      There is no mechanism to distinguish between entities and relationships, or to distinguish between different kinds of relationship that exist between entities.
      Often, attributes of different entities are mixed within one relation. Considering only the given relation, we cannot know, which attributes belong to a certain entity or relationship.
      ➔ the relational model is said to be semantically overloaded

      3. Poor support for integrity and general constraints–
      Integrity refers to the validity and consistency of stored data.
      Integrity is usually expressed in terms of constraints, which are consistency rules that the database is not permitted to violate.
      Many commercial systems do not fully support these constraints and it is necessary to build them into the applications. This is dangerous and can lead to duplication of effort and inconsistencies.
      There is no support for general constraints in the relational model, which again means that they have to be built into the DBMS or the application.
      4. Homogeneous data structure —

      The relational model assumes both horizontal and vertical homogeneity.
      • Horizontal homogeneity means that each tuple of a relation must be composed of the same attributes
      • Vertical homogeneity means that the values in a particular column of a relation must all come from the same domain
      The first normal form requires that the intersection of a row and column must be an atomic value.
      Drawbacks of Homogeneity
      • too restrictive for many (more complex) “real-world” objects
      • leads to unnatural and inefficient joins

      5. Limited Operations–
      The relational model has only a fixed set of operations, such as set and tuple-oriented operations, operations that are provided in the SQL specification.
      Since (at least older versions of) SQL is not computationally complete, new operations cannot be specified.
      This is too restrictive to model the behavior of many real-world objects.

      6. Difficulty handling recursive queries–
      Atomicity of data means that repeating groups are not allowed in the relational model.
      As a result, it is extremely difficult to handle recursive queries, that is, queries about relationships that a relation has with itself (directly or indirectly).

      7. Impedance Mismatch Older versions of SQL lack computational completeness and could not be used to develop more complex database applications.
      To overcome this problem, SQL can be embedded in a procedural programming language.
      However, this approach produces an impedance mismatch, because different programming paradigms are mixed:

      • SQL is a declarative language that handles many rows of data at a time

      • common high-level languages (such as C) are procedural languages that can handle only one row of data at a time Since the type systems are different, type checking is prevented and necessary conversions require a lot of programming effort and runtime resources.

      • 0
      • Reply
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
        • Share on WhatsApp

    Sidebar

    Ask A Question

    Stats

    • Questions 2k
    • Answers 61
    • Posts 0
    • Comments 0
    • Best Answers 0
    • Users 172
    • Tags
    amd arithmetic progressions binomial theorem complex numbers and quadratic equations conic sections determinants es-cs201-programming for problem solving exercise 1.1 (ncert class 10th maths) exercise 1.1 (ncert class 11th maths) exercise 1.1 (ncert class 12th maths) exercise 1.2 (ncert class 10th maths) exercise 1.2 (ncert class 11th maths) exercise 1.2 (ncert class 12th maths) exercise 1.3 (ncert class 10th maths) exercise 1.3 (ncert class 11th maths) exercise 1.3 (ncert class 12th maths) exercise 1.4 (ncert class 11th maths) exercise 1.4 (ncert class 12th maths) exercise 1.5 (ncert class 11th maths) exercise 1.6 (ncert class 11th maths) exercise 2.1 (ncert class 11th maths) exercise 2.1 (ncert class 12th maths) exercise 2.2 (ncert class 11th maths) exercise 2.2 (ncert class 12th maths) exercise 2.3 (ncert class 11th maths) exercise 3.1 (ncert class 10th maths) exercise 3.1 (ncert class 11th maths) exercise 3.2 (ncert class 10th maths) exercise 3.2 (ncert class 11th maths) exercise 3.3 (ncert class 10th maths) exercise 3.3 (ncert class 11th maths) exercise 3.4 (ncert class 11th maths) exercise 4.1 (ncert class 10th maths) exercise 4.1 (ncert class 11th maths) exercise 4.1 (ncert class 12th maths) exercise 4.2 (ncert class 10th maths) exercise 4.3 (ncert class 10th maths) exercise 4.4 (ncert class 10th maths) exercise 5.1 (ncert class 10th maths) exercise 5.1 (ncert class 11th maths) exercise 5.2 (ncert class 10th maths) exercise 5.2 (ncert class 11th maths) exercise 5.3 (ncert class 10th maths) exercise 5.3 (ncert class 11th maths) exercise 5.4 (ncert class 10th maths) exercise 6.1 (ncert class 11th maths) exercise 6.2 (ncert class 11th maths) exercise 6.3 (ncert class 11th maths) exercise 7.1 (ncert class 11th maths) exercise 7.2 (ncert class 11th maths) exercise 7.3 (ncert class 11th maths) exercise 7.4 (ncert class 11th maths) exercise 8.1 (ncert class 11th maths) exercise 8.2 (ncert class 11th maths) exercise 9.1 (ncert class 11th maths) exercise 9.2 (ncert class 11th maths) exercise 9.3 (ncert class 11th maths) exercise 9.4 (ncert class 11th maths) exercise 10.1 (ncert class 11th maths) exercise 10.2 (ncert class 11th maths) exercise 10.3 (ncert class 11th maths) exercise 11.1 (ncert class 11th maths) exercise 11.2 (ncert class 11th maths) exercise 11.3 (ncert class 11th maths) exercise 11.4 (ncert class 11th maths) exercise 12.1 (ncert class 11th maths) exercise 12.2 (ncert class 11th maths) exercise 12.3 (ncert class 11th maths) exercise 13.1 (ncert class 11th maths) exercise 13.2 (ncert class 11th maths) exercise 14.1 (ncert class 11th maths) exercise 14.2 (ncert class 11th maths) exercise 14.3 (ncert class 11th maths) exercise 14.4 (ncert class 11th maths) exercise 14.5 (ncert class 11th maths) exercise 15.1 (ncert class 11th maths) exercise 15.2 (ncert class 11th maths) exercise 15.3 (ncert class 11th maths) exercise 16.1 (ncert class 11th maths) exercise 16.2 (ncert class 11th maths) exercise 16.3 (ncert class 11th maths) introduction to three dimensional geometry inverse trigonometric functions limits and derivatives linear inequalities maakaut-2018 maka makaut-303-computer organization makaut-2006 makaut-2007 makaut-2008 makaut-2009 makaut-2010 makaut-2011 makaut-2012 makaut-2013 makaut-2014 makaut-2015 makaut-2016 makaut-2017 makaut-2018 makaut-2019 makaut-bs-ch-101-chemistry-1 makaut-bs-m-102-mathematics-1b makaut-bsm-101-mathematics-1 makaut-cs-301-analog and digital electronics makaut-cs-302-data-structure and algorithm makaut-cs-303-computer organization makaut-es-ee-basic-electrical-enginnering makaut-es-ss-101-electrical-engineering makaut-hm-hu-201(n)-english makaut-m-201-mathematics-ii makaut-mcq makaut-ph-101-phyiscs-1 makaut-ph-101-physics-1 makeut-ph-101-physics-1 makut-2016 makut-mcq mathematical reasoning miscellaneous-binomial theorem (ncert class 11th maths) miscellaneous-ch-1 (ncert class 12th maths) miscellaneous-ch-13 (ncert class 11th maths) miscellaneous-ch-14 (ncert class 11th maths) miscellaneous-ch-15 (ncert class 11th maths) miscellaneous-ch-16 (ncert class 11th maths) miscellaneous-complex numbers and quadratic equations (ncert class 11th maths) miscellaneous-conic sections (ncert class 11th maths) miscellaneous-introduction to three dimensional geometry (ncert class 11th maths) miscellaneous-linear inequalities (ncert class 11th maths) miscellaneous-permutations and combinations (ncert class 11th maths) miscellaneous-relations and functions (ncert class 11th maths) miscellaneous-sequences and series (ncert class 11th maths) miscellaneous-sets (ncert class 11th maths) miscellaneous-straight lines (ncert class 11th maths) miscellaneous-trigonometric functions (ncert class 11th maths) msksut-2006 ncert pair of linear equations in two variables permutations and combinations ph-101-physics-1 ph-301-physics-ii polynomials principle of mathematical induction probability quadratic equations question real numbers relations and functions sem-1 sem-3 sem-5 sequences and series sets statistics straight lines trigonometric functions

    Questions Categories

    MAKAUT
    1557Questions
    , 0Followers
    NCERT 11th Maths
    843Questions
    , 0Followers
    NCERT 10th Maths
    139Questions
    , 0Followers
    NCERT 12th Maths
    113Questions
    , 0Followers
    Advance Management of Data(AMD)
    22Questions
    , 0Followers
    Python
    1Question
    , 0Followers
    Technology
    0Questions
    , 0Followers
    R
    0Questions
    , 0Followers

    Footer

    © 2022 eduhilfe. All Rights Reserved
    With Love by eduhilfe.

    We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
    Cookie settingsACCEPT
    Privacy & Cookies Policy

    Privacy Overview

    This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
    Necessary
    Always Enabled
    Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
    Non-necessary
    Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
    SAVE & ACCEPT

    Insert/edit link

    Enter the destination URL

    Or link to existing content

      No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.