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
   239   240   241   242   243   244   245   246   247   248   249