Part B: SQL $(16$ Marks$)$ LibraryDB is a database system that keeps track of information concerning the books and their circulation in an imaginary library. Disclaimer: The data that populates the database are artificially constructed and by no means correspond to actual real$-$world data. The schema for the LibraryDB database is given below. The primary keys are underlined. The foreign keys are denoted by asterisks $(*).$ Description of the schema $$ person $--$ keeps track of the people who borrow books from the library $($personal and contact details$).$ author $--$ keeps track of personal information about authors. $$ publisher $--$ keeps track of the publisher information. $$ subject $--$ this relation keeps information about the subjects on which the library collection ha