Assignment 1 Due Date February 10 2015 11 59 PM Task List 1 2 3 4 5 Create all the tables given in the following schema Figure 4 6 Define required constraints on given tables Define triggered actions that will be attached to each foreign key constraint Insert 3 imaginary tuples into each table 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 yournetid Password yournetid Host Name onecore myds me Port 1521 SID xe You 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 returned
View Full Document
Unlocking...