Page 244 - IT_V1.0_Class10
P. 244
21 st
B. Application-based question. Century #Critical Thinking
Skills
You are managing a library database with the following tables:
Books Table
Book_ID Title Author
1 "The Great Gatsby" F. Scott Fitzgerald
2 "1984" George Orwell
3 "To Kill a Mockingbird" Harper Lee
Members Table
Member_ID Name Contact
101 Aruna 9876543210
102 Megha 9123456789
103 Mansi 9345678910
Loans Table
Loan_ID Book_ID Member_ID Loan_Date Return_Date
1 1 101 2024-12-01 2024-12-15
2 2 102 2024-12-03 2024-12-17
3 1 103 2024-12-05 2024-12-19
Now, answer the given questions:
i. What type of relationship exists between Books and Loans tables? Explain.
ii. What type of relationship exists between Members and Loans tables? Explain.
242 Information Technology Play (Ver 1.0)-X

