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 | VARCHAR(255) | NOT NULL |
| Author | VARCHAR(255) | NOT NULL |
| Publisher | VARCHAR(255) | |
| ISBN _______ __________ ________ _______ ______.
___ ___ ____ ___ ______ ____ __________ _______ ____ ________ _______.
________ ____ __________ ________ __________ _____ _______ ______ ___.
_______ _______ ______ ________ _____ ______ ______ ____.
____ ____ ________ _____ _____ _______.
_____ _________ __________ ___ _____ ________ ____ _______ __________.
_________ ____ _____ ___ _____ _________ ____ ______ ______ _____ ___ ____.
______ __________ _________ ___ ____ __________ ____ ____ _______ ________ ________.
_____ ______ ______ ___ ______ _____ ____ ____ ______ _____.
___ ________ ___ _____ ___ ______ ____ _________.
_____ ________ _________ ___ ______ ____ ______ __________ _____ _________ ___.
________ ______ ________ _____ ________ ________ _______ __________ ____ _______ _________ _____.
____ _________ ____ _____ __________ ________ ___.
___ _____ __________ _____ ____ _____ ___ ___ _______ _____ ______ ______.
____ ______ ______ ____ ___ ____.
_____ ___ _______ __________ _________ __________ ________ __________ _________ ____ _____.
_______ _________ __________ ______ _________ ________ ____ ___ ____.
________ _________ _______ ______ __________.
_____ _____ _____ ___ ______ ______ __________ __________ ________ ____.
__________ _________ ________ ______ ________ __________ ____ ______ __________ ________ _______ _____.
___ ____ _____ ________ _________ _________ ________ ________ ________ _________ ______.
______ __________ ___ ________ ________ ________ _____ _______ ________ ____ _______ ________.
__________ ___ ____ ______ _________ __________ ______ __________.
_______ ____ _________ _______ ____.
_____ ______ _________ ________ _________ _________ ____ ____ _____ _______ ___.
____ ___ ________ _________ ________ _____ _______ _________.
_______ __________ _________ ________ ______ __________.
__________ ______ _________ ______ ________ ________ ___ __________ ___ ___.
_________ ___ ____ _________ __________.
_____ ________ ___ __________ ____ ___ ________ ________.
___ _______ ___ _______ ___ _________ ______.
___ _____ ______ __________ _______.
______ _________ ___ __________ ____ ___ _______ _________.
_______ __________ _______ ______ _____ ________ _____.
________ ______ ________ ___ _____ ____ _________ _____ ___ __________.
_______ ____ _____ ____ ___ ____.
_______ ______ _____ ______ _________ ________ ____ ____ _________ ___ ______.
______ ____ ___ _________ _______ _________.
____ __________ ___ _____ ______ ______.
____ ___ __________ __________ ___ ________ ___ ______ _____ ____ ____.
______ ___ ________ ____ __________ __________.
________ ________ _________ ______ _________ _____ __________ ____ _________ ______.
_____ ________ _____ _________ _________ _________ _____ ___ ___.
__________ ___ _________ ______ _______.
____ _____ __________ ________ ___ ______ ________ _________.
_______ ______ ______ ________ _____ ____.
______ _____ __________ ______ _______ ______ ___ _________ _________ _________ _________ _______.
_________ ________ ____ _____ __________.
_____ ____ _________ _____ _____ ____ _____ _____ ______ ______.
__________ ____ _________ _______ ___ ______ ____.
___ ________ _______ ____ ___ __________ ________ _________ _________ _______ ________.
_________ _________ ___ ______ ____ _________ ____ ______.
_________ ____ __________ ___ ________.
______ _____ __________ ______ ________.
_______ _________ _________ _______ ______ _______ ________ _____ ________ ______ ________ _______.
____ _______ _____ _______ ______ ________.
____ _________ ________ _________ ________ _____ ______.
_______ _____ ___ _______ _____ _______ ____ _____ ________ _______.
_________ ______ ______ _________ ______ ____ ___ _________.
_________ __________ _________ ________ ___ _____ ________ ______ __________.
______ ______ _________ ___ ____ _____ _____ _____.
_________ _________ _____ _____ __________ __________ _______ ____ _______ ___ _________.
___ ______ ___ _____ _________ ______ _________ _________ ___.
________ ___ ____ ________ _____ _______ _____ _________ __________ ____.
____ _____ _________ ____ __________ ________.
_________ ________ ____ _________ _______ ______ _____ ________.
________ _________ ________ ________ _______ ________ _____ _____ _______.
_______ _________ _______ ____ __________ ________ ___ ________ ________ _________ ______ ____.
___ _____ _____ ___ ___ ________ _________.
__________ _______ ____ _________ ______ ___ _______ ___ ______ _____ _____.
____ _____ __________ __________ _______ ________ _______ _____ _________ __________ _____.
____ _____ ______ _____ ______ __________ _______ ________ ________ ___.
__________ ___ ________ _____ _______ ______ ___.
___ ______ ____ _________ _______.
____ ________ ____ ___ _________ ________.
____ ___ ________ _________ ________ _________ _____ ________ ____ ___ _______.
____ _______ ___ ______ _____ __________ _______ _______ _________ _____ __________ ________.
_________ ________ _____ _____ _________ ________ _____ _________ ___ ___.
_________ _________ ___ ___ _______.
___ _______ ________ _____ ___ _________ ___.
____ __________ ______ ____ ____.
________ __________ ___ _____ ________.
__________ ________ _____ ___ _______ __________ _________ ________ ___.
_______ ________.
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★★★