Assignment 1Due Date: February 10, 2015, 11:59 PMTask List1. Create all the tables given in the following schema (Figure 4.6).2. Define required constraints on given tables.3. Define triggered actions that will be attached to each foreign key constraint. 4. Insert 3 imaginary tuples into each table.5. Find the books that have been borrowed from a library branch (you will specify the branch) in last 14 days and that have not been returned yet.6. For a specific book (you will specify the book) at a specific branch (you will specify the branch), increase number of copies for the book by 5.7. Delete a user (borrower) from the system. Explain how other tables are affected from this delete based on the triggered actions you have defined at #3.o A report file that will include all SQL statements for the above task list will be uploaded to eLearning. o You are required to run all SQL statements on Oracle database server to which you can connect with the credentials you have been provided.How to connect to Oracle server?Connect to the Oracle Database server using “SQL Developer” program with following parameters:User Name: yournetidPassword: yournetidHost Name: onecore.myds.mePort: 1521SID: xeYou can download SQL Developer from the following link:http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html* Schema change:Add one additional attribute to BOOK_LOANS table with name “Return_date”. When a book is borrowed, Return_date should take initial value of NULL. When the book is returned, Return_date will be updated with the date the book is
View Full Document