Map the object classes created in Question 2 above into database tables. Make necessary assumptions.
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 | VARCHAR(20) | UNIQUE |
| Category | VARCHAR(100) | |
| AvailabilityStatus | BOOLEAN | DEFAULT TRUE |
2. Member Class
Assumed attributes:
* MemberID (Primary Key)
* Name
* Email
* Address
* PhoneNumber
* MembershipDate
Table: Member
| Column Name | Data Type | Constraints |
| -------------- |
________ _________ _________ ______ _______ _____ ___ __________ ________.
__________ ___ ________ _______ __________ ________ __________ _______ ______ ____.
___ _____ __________ ________ ________ ____ ______ _________ ___ __________ ___ ___.
_______ ____ __________ ________ _____ __________ _____ ______ _____ __________.
_____ ___ __________ ________ ________.
_____ ________ ___ __________ _______ _________.
__________ _______ _______ _________ __________ _____ _______.
___ _____ ______ _____ _______ _____ __________ _________ _______ _____.
________ ________ ___ ______ ____ __________.
______ ________ ____ _____ _______ _________ ________ ________ ___.
____ _________ ________ _____ ____ _________.
__________ _____ __________ _____ ________ _______ _________ ____ __________ ___ _________.
_____ __________ __________ _________ ______ _______ _____.
_____ ___ _______ ________ ______ ________ ________ __________ ___.
______ _____ ________ ___ __________ _________ ___ _________ ______ ________.
_________ ___ _______ ________ ________ _________ __________ _______ ___ _____ ___ _________.
__________ _____ ________ __________ ______ ______.
______ ____ ________ _____ ___ _______ _______ _________ _________ ________ _____ _____.
______ _____ __________ ______ ____ ___ ____ _____ ___ ______ ___ _________.
___ _________ ___ _____ _____ __________ ____ _______ _________.
______ ______ ______ _____ ______ ___ _______ ______ ________.
____ ___ __________ __________ ___ ___ __________ _____ ______ _____ _______.
_______ _____ ______ _________ ______ _____ _____ _________ __________ _____ _____ _________.
_____ ____ _________ _____ ____ _____.
______ ______ ________ _____ _______ __________ ______.
_____ _______ ________ _________ ___ ______ _______ _____.
______ ______ _________ __________ ___ ___ ___ ______.
_______ ____ ___ ____ _________ ______ ___ ______ ___ _________.
______ _________ _____ ____ ___ ________ ______ ________ _________ _____ _______.
________ ___ ___ ______ ___ ____ _______ _____ _________ ____.
_________ _____ ______ ___ ___ __________ _______ _________.
_________ _____ _______ ___ ______ _______ _____ ________.
_____ _______ ____ _____ ____ _______ _______ _____ _____ ___.
__________ ________ __________ __________ ______ _____ ____ ____ ______ ______ ___.
_________ ________ ___ _____ _________.
__________ ______ _________ __________ ____ _______ _______.
_________ _______ ____ _________ ___ ______ _________ ___ _____ __________ __________.
________ ____ __________ ____ __________.
___ _____ ____ ______ ____ _________.
___ ________ ___ __________ ___ _____.
_________ ___ _____ _____ ____ ___ _____ ________ _____ __________ ____ ____.
_______ ______ _____ __________ _________ ________ __________ _____ ______ ____.
___ __________ _____ ______ __________ _____ _________ ________ _________ ___ _______.
___ _____ _________ ___ __________ _________ ________ ____ _________ _______.
_____ ____ _______ ____ ___ ___ ___ ________ ____ ______.
_________ __________ __________ ____ __________ ____ ______ ____ ________.
____ _____ ___ __________ ___ ____ ____.
___ ___ ________ __________ ___ _________ _________.
____ ___ ____ _______ ___ ________ ___ _______ _________.
____ _________ _____ _______ ________ __________ _______ ______ _________.
_____ __________ ____ __________ ____ _____ _______ _____ _____ ________ ________ __________.
__________ ____ __________ _________ _________ ___.
_________ _____ _____ _______ ________ _____.
___ ______ _______ _______ _____ _____.
_____ ___ ____ _______ ___ ____ _________ ____ _________.
___ _____ _____ _________ _________ _________ _______ ______ ___.
_______ _______ _________ _______ ____ _______ _________ ____ _____.
______ _______ _________ ______ ________ _________.
________ ________ _______ _______ _______ ________ ____ ___ ________ ___ _____ _________.
_________ _____ _____ ________ ________ ___ _____ _________ _______ _______.
______ _____ _______ _____ __________ ________ ___ _________.
_____ _____ ________ ________ _______ ______.
_________ ___ ________ ____ ___ __________ _____ _____ _________ __________ __________ _______.
______ ________ ________ ____ ____ ___.
_______ _______ _______ ________ ______.
________ ________ _________ _______ _____ ____ ____ ___ _______ __________ _____.
________ ___ _______ ______ _____ ______ _______ ______ __________.
________ __________ ____ ___ ______ ____ ________ ___ _____ ______ _________ ______.
_____ ____ _________ ________ ______ __________ ____ ________.
_________ ____ _________ _________.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
✓ Unlock up to 60% of the answer
✓ No payment required