There are 3 levels of abstraction in DBMS<\/p>\n

<\/p>\n

Physical Level<\/strong><\/h2>\n

\n
• It is the lowest level of data abstraction and is managed by DBMS.<\/li>\n
• This level shows how the data is stored in the database.<\/li>\n
• Data storage descriptions and details of this level are hidden from system admins, developers, and users<\/li>\n<\/ul>\n

  Logical Level<\/strong><\/h2>\n

  \n
  • Logical level is the second level in data abstraction, which states the type of data and the relationship among the data that is stored in the database.<\/li>\n
  • It is a level on which system admin and developers work.<\/li>\n<\/ul>\n

    <\/p>\n

    View Level<\/strong><\/h2>\n

    \n
    • This is the highest level of data abstraction, which shows\/states only a part of the database.<\/li>\n
    • View level is a level that describes a part of the database and hides the details of the table and its schema and storage from its users.<\/li>\n
    • The result of a query is an example of view-level data abstraction.<\/li>\n
    • A table created by selecting fields from one or more tables present in the database can be shown using this view.<\/li>\n<\/ul>\n

      \n","protected":false},"excerpt":{"rendered":"

      There are 3 levels of abstraction in DBMS Physical Level It is the lowest level of data abstraction and is managed by DBMS. This level shows how the data is stored in the database. Data storage descriptions and details of this level are hidden from system admins, developers, and users Logical Level Logical level is […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"footnotes":""},"categories":[7157],"tags":[18952,18957,18954,18958,18955,18950,18953,18956,18951],"class_list":["post-5017","post","type-post","status-publish","format-standard","hentry","category-dbms","tag-data-abstraction","tag-data-abstraction-example","tag-data-abstraction-in-dbms","tag-data-abstraction-in-dbms-examples","tag-data-abstraction-levels-in-dbms","tag-definition-of-level-of-abstraction","tag-explain-levels-of-abstraction-in-dbms","tag-levels-of-data-abstaction-in-dbms","tag-what-is-data-abstaction-in-dbms"],"yoast_head":"\n