Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 21 views

    Mapping E-R To Relational Model (ROLL NO:35, S5 CS2) : September 22, 2013

    Uploaded by

    Rafiullah Rustam
    This document summarizes mapping an ER diagram for a library management system to a relational model. The ER diagram includes entities for books, publishers, members, sections, and staff. Relationships include books being published by publishers and borrowed by members, books being managed by staff and categorized in sections. Each entity is mapped to a table with attributes. Relationships are mapped to tables with foreign keys linking the relevant entity tables.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Mapping E-R To Relational Model (ROLL NO:35, S5 CS2) : September 22, 2013

    Uploaded by

    Rafiullah Rustam
    21 views2 pages
    This document summarizes mapping an ER diagram for a library management system to a relational model. The ER diagram includes entities for books, publishers, members, sections, and staff. Relationships include books being published by publishers and borrowed by members, books being managed by staff and categorized in sections. Each entity is mapped to a table with attributes. Relationships are mapped to tables with foreign keys linking the relevant entity tables.

    Original Description:

    Original Title

    Documentه

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document summarizes mapping an ER diagram for a library management system to a relational model. The ER diagram includes entities for books, publishers, members, sections, and staff. Relationships include books being published by publishers and borrowed by members, books being managed by staff and categorized in sections. Each entity is mapped to a table with attributes. Relationships are mapped to tables with foreign keys linking the relevant entity tables.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    21 views2 pages

    Mapping E-R To Relational Model (ROLL NO:35, S5 CS2) : September 22, 2013

    Uploaded by

    Rafiullah Rustam
    This document summarizes mapping an ER diagram for a library management system to a relational model. The ER diagram includes entities for books, publishers, members, sections, and staff. Relationships include books being published by publishers and borrowed by members, books being managed by staff and categorized in sections. Each entity is mapped to a table with attributes. Relationships are mapped to tables with foreign keys linking the relevant entity tables.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    MAPPING E-R TO RELATIONAL MODEL

    (ROLL NO:35 ,S5 CS2)


    September 22, 2013
    savitaajayan Mapping ER to Realtional Leave a comment
    E-R diagram of library management system is given:

    Books are published by publisher and are borrowed by members of the library .

    Books are managed by staffs of the library and are categorized on separate sections .

    Each book is uniquely identified by book-id and publisher is identified by pub-id.

    Also each member has his /her own unique member-id (M-id).

    Staffs are identified by their staff-id and also each section has unique section code.

    Each book hasauthor, title and price also.

    Each publisher has name and address .All staffs has name ,post and salary .

    Each section of the library has number and name. Each member has address, name, membership type  and
    date of membership.

    Books are borrowed on the basis of return date, due date and date of issue.

    E-R DIAGRAM

    Mapping into relational model

    Entities:

    Publisher
    Pub_id Name Address

    Member

    M_id M_date M_type mname maddr

    Books

    Book_id Author Title Price

    Section

        S-code S-name S-no

    Staff

    S-id S-name Post Salary

    Relationships

    Published by:

    Book_id Pub_id

    Borrow by:

    Duedate returndate issuedate Book-id M_id

    Managed by:

    S_id Book_id

    Categorized by:

    S_code Book_id

    You might also like