Map the object classes created in Question 2 above into database table

Question

Map the object classes created in Question 2 above into database tables. Make necessary assumptions.

08 May 2025

Answer :

Word Count : 933

To map the object classes created in Question 2 into database tables within the context of Object-Oriented Analysis and Design (OOAD), we must follow the object-relational mapping (ORM) approach. ORM is the process of converting object classes into relational database structures. In OOAD, each object class typically corresponds to a table in the database, attributes of the object class become fields (columns), and relationships between classes become foreign keys.

Assuming the classes created in Question 2 were part of a simple Library Management System, the object classes could be: `Book`, `Member`, `Librarian`, `Loan`, and `Fine`. Based on these assumptions, below is the mapping of these classes into database tables.

1. Book Class

Assumed attributes:

* BookID (Primary Key)
* Title
* Author
* Publisher
* ISBN
* Category
* AvailabilityStatus

Table: Book

| Column Name | Data Type | Constraints |
| ------------------ | ------------ | ------------ |
| BookID | INT | PRIMARY KEY |
| Title ______ ___ __________ _________ _______ ______ ___.
_______ ____ __________ _____ _______.
__________ ________ _______ _________ __________ ____.
________ _____ _______ ______ ___ ____ _________ ___.
______ _______ _____ ______ _____.
____ _________ ______ ______ ______ _________ _________ _____ ______.
____ ______ ________ __________ _________ _______ __________ _____ ___ _______ ______ _________.
__________ ___ __________ ________ __________ ____ ______ _____ ____ _____.
___ ______ ___ __________ ____ _______.
_____ ______ ________ ________ ________ _____ ____ __________ __________ ____ _____.
_____ ______ _________ _________ _____ _________ ______ _________ ______.
___ _______ _______ ______ __________ __________ ________ ______ _______.
__________ _____ ____ __________ _________ ______ ___ ___ _____.
____ ___ ________ ___ ___.
___ ______ _______ ______ ________ _____ ____ ___ _________ ________ _______.
________ _________ __________ ________ _______ __________ ______ _______ _________ ___ ___.
________ ______ ___ ____ ______ ___.
__________ __________ ____ ________ __________ _______ _____ _______ ________.
_______ __________ ________ _______ ______ ________ __________.
_________ __________ _____ ________ ____ _________ ______ ____ _______ _____ _____ _____.
____ ___ _________ ______ ______.
_______ ____ _____ ______ ______ ___ __________ ____ ___ ____.
______ _____ _____ ____ _________ ________ ___ ______ _____.
________ ____ ____ ____ _________ ___ ___ ________ _______.
________ ______ ___ _________ _____.
_______ _____ ____ __________ ________ ___ __________ _____ __________ __________ ______.
__________ ___ ________ _________ ____.
_____ _____ _________ _________ _______ ___ __________ _________ ____ __________ _________.
________ ____ _____ _______ ______ _______ ________ ______.
______ ______ ___ ___ __________.
_________ __________ ________ ___ _______.
_________ ____ ______ ____ _________ ___ ___ _________ ____ _____ ________.
_________ ______ ___ ______ ______ _____ ___ _______ ____ _________ ____ ____.
____ _____ ___ _____ __________ _____ ________ ______.
___ _______ ________ __________ ____ _____ ________ ________ _______ ________ ________.
_______ _____ __________ ____ ___ ____ ________ __________ ______ _______ ____ _____.
_____ ________ ____ ____ ___ ________ ______ __________ ___ _____.
________ ______ ____ _________ _______ _______ _______ ____ _________ __________.
_____ ___ __________ ________ __________ ______ ________ ______ ______ _________ ________.
__________ ___ ___ __________ _____ ___ _____ _______ __________ ________ ______.
________ ____ ______ ___ _____ ____ __________ ______.
_______ _____ _______ __________ ________ ___ ________ __________ __________.
_________ _________ __________ ______ ___ ___ ________.
__________ ____ _________ ________ ________ __________ _________ _________ _________ ___.
_______ ________ __________ ______ __________ _____ ______ _____ _____ ____ _______ ___.
________ ________ ______ __________ ________.
____ _________ _________ ________ ___.
___ ____ __________ _____ _______ ____ ________ ____.
__________ ___ __________ ____ ___.
__________ _______ ___ ________ ________ __________.
________ __________ _____ _______ _________ ________ ___ ___ __________.
____ _____ _________ ______ __________ _______ _______ _______ ____ ________.
______ ______ ____ __________ ________ __________ ________ ________ ____ ______.
__________ _______ _______ ________ ______ _________ __________.
_________ ______ _________ ________ _________ ___.
______ _____ ____ _________ _______ _______ ______.
__________ __________ ___ ______ _________ ________ _________.
_______ _____ _________ ______ ____ _________ ____ ____ ________ _________ ____.
_______ ______ _____ _____ _______ ________ ____ _________.
_____ _____ _______ __________ ___ ____ ___.
______ ___ ________ _______ _____ _________.
_______ ____ _____ _____ _________ _________ ______ _________ __________ __________.
__________ ___ ______ __________ ________ _________ ___ ________ _________ ________ ___ ____.
_______ ____ ______ ______ ______ ___.
_________ _______ _________ __________ ____ ___ __________ ____ _____ ____ __________ _________.
_____ ______ ______ _________ ____ _________ ________ ____ ______ _____ ____ ___.
_______ __________ ___ ________ ___.
__________ ___ _______ ________ ______.
__________ ____ ________ __________ ________ _________ __________ ________ _______ ____.
__________ ______ __________ __________ _______ ___ _________ _____ ____ _____ ____ ___.
_________ _________ __________ _________ __________ _________ _____ ________ ____ _______ ________.
______ _____ _______ __________ _________ _________ ___ ____ ___.
___ _________ _____ ____ _________ _______ ____ ________ ____ ________ ____.
______ _______ ____ ___ ___ _____.
___ ______ ______ ___ ____ ______.
_________ _______ ___ __________ __________ ________ ________ __________.
____ __________ _________ __________ __________ _______ __________.
_____ __________ _________ ___ _______ ________ ______ ___ ________ ______.
__________ ___ _____ _____ _______ _________ ___ ________ ___ ______ ____ _________.
_______ __________ ___ _____ ____ ______ ________ _________.
__________ ________ ____ ______ ________.
_______ _________ ______ __________ ____ ______ ________ _________ __________ ____ _______ ______.
____ ___ ___ _________ ______.
_____ _____ ______ ___ _________ _____.
_________ ___ _____ ____ __________ ____ _________ ____ ______ _________ _____.
__________ ___ ______ _________ _______ ________ _________ _______ _____ ______ ____ _________.
_____ ________ ______ ______ ________.
________ ___ __________ ________ _____ _________ __________ ______.
_______ __________.
Get Full Answer on WhatsApp

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★