{"id":188335,"date":"2025-02-06T18:23:35","date_gmt":"2025-02-06T18:23:35","guid":{"rendered":"https:\/\/learnexams.com\/blog\/?p=188335"},"modified":"2025-02-06T18:23:37","modified_gmt":"2025-02-06T18:23:37","slug":"diagram-of-library-management-system","status":"publish","type":"post","link":"https:\/\/www.learnexams.com\/blog\/2025\/02\/06\/diagram-of-library-management-system\/","title":{"rendered":"Diagram of Library Management System"},"content":{"rendered":"\n<p>Diagram of Library Management System<\/p>\n\n\n\n<p>The library management system has a database that shows the relationships between the entities such as a book, publisher, and member. Since this is a simple system, it has only three entities.<\/p>\n\n\n\n<p>Entities and Attributes<\/p>\n\n\n\n<p>? Book Entity: It has author, book_ID, title, price, and availability.<\/p>\n\n\n\n<p>? Publisher Entity: It has publisher_ID, publisher_address, and publisher_name.<\/p>\n\n\n\n<p>? Member Entity: It has member_ID, member_date, member_type, member_address, member_name, and expiry_date.<\/p>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>ER Diagram of Online Shopping System<\/li>\n<\/ol>\n\n\n\n<p>Entities and Attributes<\/p>\n\n\n\n<p>? Website\/Application Entity: Attributes are domain name and app name.<\/p>\n\n\n\n<p>? Customer Entity: Attributes are username, password, email address, mobile number, country name, district, address, C_id.<\/p>\n\n\n\n<p>? Products Entity: Attributes are product ID, P_name, P_category, P_price, P_availability.<\/p>\n\n\n\n<p>? Admin Entity: Attributes are username, password, A_id.<\/p>\n\n\n\n<p>? Shopping Cart Entity: Attributes are product id, product name, total price, billing products.<\/p>\n\n\n\n<p>? Registration Entity: Attributes are user id, username, password, forgot password, signup.<\/p>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-ast-global-color-6-color\"><strong>The Correct Answer and Explanation is :<\/strong><\/mark><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">ER Diagram of Library Management System<\/h3>\n\n\n\n<p><strong>Entities and Attributes:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Book Entity<\/strong>:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Attributes<\/strong>:<ul><li><code>author<\/code><\/li><li><code>book_ID<\/code> (Primary Key)<\/li><li><code>title<\/code><\/li><li><code>price<\/code><\/li><li><code>availability<\/code><\/li><\/ul>The Book entity holds details about books available in the library. <code>book_ID<\/code> is the unique identifier for each book, and <code>availability<\/code> indicates whether the book is currently available or checked out.<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Publisher Entity<\/strong>:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Attributes<\/strong>:<ul><li><code>publisher_ID<\/code> (Primary Key)<\/li><li><code>publisher_address<\/code><\/li><li><code>publisher_name<\/code><\/li><\/ul>The Publisher entity represents the publisher of books. <code>publisher_ID<\/code> uniquely identifies each publisher.<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Member Entity<\/strong>:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Attributes<\/strong>:<ul><li><code>member_ID<\/code> (Primary Key)<\/li><li><code>member_date<\/code><\/li><li><code>member_type<\/code><\/li><li><code>member_address<\/code><\/li><li><code>member_name<\/code><\/li><li><code>expiry_date<\/code><\/li><\/ul>The Member entity stores information about library members. <code>member_ID<\/code> is a unique identifier for each member, and <code>expiry_date<\/code> specifies when the membership expires.<\/li>\n<\/ul>\n\n\n\n<p><strong>Relationships<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A <strong>Member<\/strong> can borrow multiple <strong>Books<\/strong>, forming a <strong>one-to-many<\/strong> relationship from Member to Book.<\/li>\n\n\n\n<li>A <strong>Publisher<\/strong> can publish multiple <strong>Books<\/strong>, forming a <strong>one-to-many<\/strong> relationship from Publisher to Book.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">ER Diagram of Online Shopping System<\/h3>\n\n\n\n<p><strong>Entities and Attributes:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Website\/Application Entity<\/strong>:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Attributes<\/strong>:<ul><li><code>domain_name<\/code><\/li><li><code>app_name<\/code><\/li><\/ul>Represents the online platform for shopping.<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Customer Entity<\/strong>:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Attributes<\/strong>:<ul><li><code>username<\/code><\/li><li><code>password<\/code><\/li><li><code>email address<\/code><\/li><li><code>mobile number<\/code><\/li><li><code>country name<\/code><\/li><li><code>district<\/code><\/li><li><code>address<\/code><\/li><li><code>C_id<\/code> (Primary Key)<\/li><\/ul>Represents customers who use the online shopping platform. The unique identifier is <code>C_id<\/code>.<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Products Entity<\/strong>:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Attributes<\/strong>:<ul><li><code>product_ID<\/code> (Primary Key)<\/li><li><code>P_name<\/code><\/li><li><code>P_category<\/code><\/li><li><code>P_price<\/code><\/li><li><code>P_availability<\/code><\/li><\/ul>Contains details about the products available for purchase. Each product has a unique <code>product_ID<\/code>.<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Admin Entity<\/strong>:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Attributes<\/strong>:<ul><li><code>username<\/code><\/li><li><code>password<\/code><\/li><li><code>A_id<\/code> (Primary Key)<\/li><\/ul>Represents administrators who manage the platform.<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Shopping Cart Entity<\/strong>:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Attributes<\/strong>:<ul><li><code>product_id<\/code><\/li><li><code>product_name<\/code><\/li><li><code>total_price<\/code><\/li><li><code>billing_products<\/code><\/li><\/ul>Represents the cart where customers add products for purchase.<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Registration Entity<\/strong>:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Attributes<\/strong>:<ul><li><code>user_id<\/code><\/li><li><code>username<\/code><\/li><li><code>password<\/code><\/li><li><code>forgot_password<\/code><\/li><li><code>signup<\/code><\/li><\/ul>Manages user registration on the platform.<\/li>\n<\/ul>\n\n\n\n<p><strong>Relationships<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A <strong>Customer<\/strong> can have many <strong>Shopping Carts<\/strong>, representing a <strong>one-to-many<\/strong> relationship.<\/li>\n\n\n\n<li>A <strong>Shopping Cart<\/strong> can contain multiple <strong>Products<\/strong>, forming a <strong>many-to-many<\/strong> relationship between Products and Shopping Cart.<\/li>\n\n\n\n<li>A <strong>Customer<\/strong> can make multiple <strong>Registrations<\/strong>, which might form a <strong>one-to-many<\/strong> relationship if registration details are tracked over time.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Explanation<\/h3>\n\n\n\n<p>The <strong>Library Management System<\/strong> involves managing books, publishers, and members. Relationships are primarily <strong>one-to-many<\/strong>: a publisher can publish many books, and a member can borrow multiple books.<\/p>\n\n\n\n<p>In the <strong>Online Shopping System<\/strong>, the relationships are more complex:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>The <strong>Customer<\/strong> can register, manage a shopping cart, and purchase many products, forming one-to-many or many-to-many relationships with other entities like <strong>Products<\/strong> and <strong>Shopping Cart<\/strong>.<\/li>\n\n\n\n<li><strong>Products<\/strong> and <strong>Shopping Cart<\/strong> have a <strong>many-to-many<\/strong> relationship, where each cart can have multiple products, and a product can appear in multiple carts.<\/li>\n\n\n\n<li><strong>Admin<\/strong> manages the platform, ensuring proper admin privileges.<\/li>\n<\/ol>\n\n\n\n<p>Both systems rely on entities with well-defined relationships to manage various processes efficiently. The Library system is more focused on borrowing books, while the Online Shopping system supports registration, cart management, and product purchases.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Diagram of Library Management System The library management system has a database that shows the relationships between the entities such as a book, publisher, and member. Since this is a simple system, it has only three entities. Entities and Attributes ? Book Entity: It has author, book_ID, title, price, and availability. ? Publisher Entity: It [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[25],"tags":[],"class_list":["post-188335","post","type-post","status-publish","format-standard","hentry","category-exams-certification"],"_links":{"self":[{"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/posts\/188335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/comments?post=188335"}],"version-history":[{"count":0,"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/posts\/188335\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/media?parent=188335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/categories?post=188335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/tags?post=188335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}