For the following questions, use the relational schema defined as follow. Book BookCopy (copyNo, ISBN, available) Borrower(borrowerNo, borrowerName, borrowerAddress) BookLoan (copyNo, dateOut, dateDue, borrowerNo) (ISBN, title, author, edition, year) where Book BookCopy contains details of the individual copies of books in the library and copyNo is the Borrowercontains details of library members who can borrow books and borrowerNo is the BookLoan contains details of the book copies that are borrowed by library members and contains details of book titles in the library and the ISBN is the primary key. primary key. ISBN is a foreign key identifying the book title. primary key copyNo/dateOut forms the primary key. borrowerNo is a foreign key identifying the borrower. 1. Create the Library schema and all corresponding tables in the schema. Include statements to drop the schema if they already exist. Include any constrains or default value that you think are necessary 2. For each table you just created, add 5 rows to that 3. Write an ALTER TABLE statement that adds one new column that provides phone number of the borrower to the Borrower table you already created. 4. Write an ALTER TABLE statement that modifies the Book table you already created so that the book title in each row has to be unique 5. What happen when you try to insert a row with a duplicate book title to the Book table? For the following questions, use the relational schema defined as follow. Book BookCopy (copyNo, ISBN, available) Borrower(borrowerNo, borrowerName, borrowerAddress) BookLoan (copyNo, dateOut, dateDue, borrowerNo) (ISBN, title, author, edition, year) where Book BookCopy contains details of the individual copies of books in the library and copyNo is the Borrowercontains details of library members who can borrow books and borrowerNo is the BookLoan contains details of the book copies that are borrowed by library members and contains details of book titles in the library and the ISBN is the primary key. primary key. ISBN is a foreign key identifying the book title. primary key copyNo/dateOut forms the primary key. borrowerNo is a foreign key identifying the borrower. 1. Create the Library schema and all corresponding tables in the schema. Include statements to drop the schema if they already exist. Include any constrains or default value that you think are necessary 2. For each table you just created, add 5 rows to that 3. Write an ALTER TABLE statement that adds one new column that provides phone number of the borrower to the Borrower table you already created. 4. Write an ALTER TABLE statement that modifies the Book table you already created so that the book title in each row has to be unique 5. What happen when you try to insert a row with a duplicate book title to the Book table
