<style>/*<link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=5177253347459046650&zx=c88387bd-d307-4f3c-98d6-af53a8eefd08' media='none' onload='if(media!='all')media='all'' rel='stylesheet'/><noscript><link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=5177253347459046650&zx=c88387bd-d307-4f3c-98d6-af53a8eefd08' rel='stylesheet'/></noscript>
<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

<!-- data-ad-client=ca-pub-7994639475907326 -->

</head><body>*/</style>

Database Management System (DBMS)

Desmond Akachukwu

31 Dec, 2022

Database Management System (DBMS)

A database management system (DBMS) is a software application or set of tools that is used to create, manage, and manipulate a database. A database is a structured collection of data that is stored electronically and is designed to be accessed and updated efficiently. The DBMS is responsible for managing the data stored in the database, including storing, organizing, and retrieving the data as needed.

There are several different types of DBMSs, including:

Relational DBMS (RDBMS): A relational DBMS is a type of DBMS that is based on the relational model, which organizes data into tables (i.e. relations) that consist of rows (i.e. tuples) and columns (i.e. attributes). RDBMSs are designed to support the Structured Query Language (SQL) for querying and manipulating data, and are widely used in a variety of applications and industries.
Object-Oriented DBMS (OODBMS): An object-oriented DBMS is a type of DBMS that is based on the object-oriented programming paradigm, which represents data as objects with attributes and methods. OODBMSs are designed to support the storage and management of complex data structures and relationships, and are often used in applications that require advanced modeling and data manipulation capabilities.
NoSQL DBMS: A NoSQL (i.e. "Not Only SQL") DBMS is a type of DBMS that is designed to support a wide range of data models and structures, including structured, semi-structured, and unstructured data. NoSQL DBMSs are often used in large-scale, distributed systems that require high scalability and performance, and may not support the full range of SQL capabilities.

Functions of Database Management System

Some of the key functions and features of a DBMS include:

Data storage and organization
Data manipulation and querying
Data security and access control
Concurrency control and transactions
Data integrity and reliability
Backup and recovery

DBMSs are an essential component of modern computing and are used in a wide range of applications, including business, finance, healthcare, government, and more. They provide a reliable and efficient way to store, manage, and access large amounts of data, and are an important consideration in the design and implementation of data-driven systems and applications.

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/654365252-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AAVkm1v6s-oYpmk03wCtqsdz8aiL:1778497207577';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d5177253347459046650','//alphalearnng.blogspot.com/2022/12/database-management-system-dbms.html','5177253347459046650');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '5177253347459046650', 'title': 'AlphaLearnng', 'url': 'http://alphalearnng.blogspot.com/2022/12/database-management-system-dbms.html', 'canonicalUrl': 'http://alphalearnng.blogspot.com/2022/12/database-management-system-dbms.html', 'homepageUrl': 'http://alphalearnng.blogspot.com/', 'searchUrl': 'http://alphalearnng.blogspot.com/search', 'canonicalHomepageUrl': 'http://alphalearnng.blogspot.com/', 'blogspotFaviconUrl': 'http://alphalearnng.blogspot.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': false, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22AlphaLearnng - Atom\x22 href\x3d\x22http://alphalearnng.blogspot.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22AlphaLearnng - RSS\x22 href\x3d\x22http://alphalearnng.blogspot.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22AlphaLearnng - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/5177253347459046650/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22AlphaLearnng - Atom\x22 href\x3d\x22http://alphalearnng.blogspot.com/feeds/7159727807851971656/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-7994639475907326', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/67692f944efa753a', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'item', 'postId': '7159727807851971656', 'pageName': 'Database Management System (DBMS)', 'pageTitle': 'AlphaLearnng: Database Management System (DBMS)', 'metaDescription': 'A database management system (DBMS) is a software application or set of tools that is used to create, manage, and manipulate a database'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Database Management System (DBMS)', 'description': 'A database management system (DBMS) is a software application or set of tools that is used to create, manage, and manipulate a database', 'url': 'http://alphalearnng.blogspot.com/2022/12/database-management-system-dbms.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 7159727807851971656}}, {'name': 'widgets', 'data': [{'title': 'Upload Image', 'type': 'Image', 'sectionId': 'upload-image', 'id': 'Image10'}, {'title': 'AlphaLearnng (Header)', 'type': 'Header', 'sectionId': 'upload-image', 'id': 'Header1'}, {'title': 'Search This Blog', 'type': 'BlogSearch', 'sectionId': 'upload-image', 'id': 'BlogSearch1'}, {'type': 'AdSense', 'sectionId': 'upload-image', 'id': 'AdSense2'}, {'type': 'Attribution', 'sectionId': 'upload-image', 'id': 'Attribution1'}, {'title': 'Labels', 'type': 'Label', 'sectionId': 'upload-image', 'id': 'Label1'}, {'title': '', 'type': 'ReportAbuse', 'sectionId': 'upload-image', 'id': 'ReportAbuse1'}, {'title': '', 'type': 'PopularPosts', 'sectionId': 'upload-image', 'id': 'PopularPosts1', 'posts': [{'title': 'Human Circulatory System ', 'id': 1688089549946060409}, {'title': 'Outline and explain the various homeostatic functions of the liver in mammals', 'id': 4581707389985147101}, {'title': 'Faraday\x27s Law of Induction', 'id': 6615587226408556535}]}, {'title': '', 'type': 'PageList', 'sectionId': 'upload-image', 'id': 'PageList1'}, {'title': 'Contact Form', 'type': 'ContactForm', 'sectionId': 'upload-image', 'id': 'ContactForm1'}, {'title': 'Logo', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML10'}, {'title': 'Icons, Dark, Search', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList10'}, {'title': 'Menu', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList11'}, {'title': '#', 'type': 'HTML', 'sectionId': 'before-blog', 'id': 'HTML3'}, {'title': 'Thank you for supporting us!', 'type': 'HTML', 'sectionId': 'before-blog', 'id': 'HTML1'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog1', 'posts': [{'id': '7159727807851971656', 'title': 'Database Management System (DBMS)', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'author', 'label': 'By'}, {'name': 'timestamp', 'label': 'd MMM, yyyy'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'share', 'label': ''}, {'name': 'comments', 'label': 'Comment'}, {'name': 'labels', 'label': 'Labels:'}, {'name': 'icons', 'label': ''}]}], 'allBylineItems': [{'name': 'author', 'label': 'By'}, {'name': 'timestamp', 'label': 'd MMM, yyyy'}, {'name': 'share', 'label': ''}, {'name': 'comments', 'label': 'Comment'}, {'name': 'labels', 'label': 'Labels:'}, {'name': 'icons', 'label': ''}]}, {'title': '#', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML5'}, {'title': '#', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML14'}, {'title': '#You may also like', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML15'}, {'title': 'Cookie Notice', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML2'}, {'title': 'Contact Form', 'type': 'ContactForm', 'sectionId': 'footer-widget', 'id': 'ContactForm2'}, {'title': 'About Us', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML21'}, {'title': 'Newsletter', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML22'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML23'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML24'}]}]);
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image10', 'upload-image', document.getElementById('Image10'), {'resize': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'upload-image', document.getElementById('Header1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogSearchView', new _WidgetInfo('BlogSearch1', 'upload-image', document.getElementById('BlogSearch1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_AdSenseView', new _WidgetInfo('AdSense2', 'upload-image', document.getElementById('AdSense2'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_AttributionView', new _WidgetInfo('Attribution1', 'upload-image', document.getElementById('Attribution1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label1', 'upload-image', document.getElementById('Label1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ReportAbuseView', new _WidgetInfo('ReportAbuse1', 'upload-image', document.getElementById('ReportAbuse1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts1', 'upload-image', document.getElementById('PopularPosts1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'upload-image', document.getElementById('PageList1'), {'title': '', 'links': [{'isCurrentPage': false, 'href': 'http://basicacadem.blogspot.com/', 'title': 'Home'}, {'isCurrentPage': false, 'href': 'http://alphalearnng.blogspot.com/p/life-and-light.html', 'id': '3671509874115685402', 'title': 'LIFE \x26 LIGHT'}, {'isCurrentPage': false, 'href': 'http://alphalearnng.blogspot.com/p/about-us.html', 'id': '4426598469096691194', 'title': 'About Us'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm1', 'upload-image', document.getElementById('ContactForm1'), {'contactFormMessageSendingMsg': 'Sending...', 'contactFormMessageSentMsg': 'Your message has been sent.', 'contactFormMessageNotSentMsg': 'Message could not be sent. Please try again later.', 'contactFormInvalidEmailMsg': 'A valid email address is required.', 'contactFormEmptyMessageMsg': 'Message field cannot be empty.', 'title': 'Contact Form', 'blogId': '5177253347459046650', 'contactFormNameMsg': 'Name', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Message', 'contactFormSendMsg': 'Send', 'contactFormToken': 'AAVkm1vWwumYibVPTkdLWtUl6mQ_:1778497207577', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML10', 'header-main', document.getElementById('HTML10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList10', 'header-main', document.getElementById('LinkList10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList11', 'header-main', document.getElementById('LinkList11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'before-blog', document.getElementById('HTML3'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'before-blog', document.getElementById('HTML1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'blog-post', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML5', 'ads-post', document.getElementById('HTML5'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML14', 'ads-post', document.getElementById('HTML14'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML15', 'ads-post', document.getElementById('HTML15'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML2', 'footer-widget', document.getElementById('HTML2'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm2', 'footer-widget', document.getElementById('ContactForm2'), {'contactFormMessageSendingMsg': 'Sending...', 'contactFormMessageSentMsg': 'Your message has been sent.', 'contactFormMessageNotSentMsg': 'Message could not be sent. Please try again later.', 'contactFormInvalidEmailMsg': 'A valid email address is required.', 'contactFormEmptyMessageMsg': 'Message field cannot be empty.', 'title': 'Contact Form', 'blogId': '5177253347459046650', 'contactFormNameMsg': 'Name', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Message', 'contactFormSendMsg': 'Send', 'contactFormToken': 'AAVkm1vWwumYibVPTkdLWtUl6mQ_:1778497207577', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML21', 'footer-widget', document.getElementById('HTML21'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML22', 'footer-widget', document.getElementById('HTML22'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML23', 'copyright', document.getElementById('HTML23'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML24', 'jet-options', document.getElementById('HTML24'), {}, 'displayModeFull'));
</script>
</body>*/</style>