Oracle SQL Database

Thank you

Part 1 Creating and redesigning an existing database (2 %)- Use your following database created in the your account on CSOM database and perform all queries using your own account. This data base should have three tables. ' books (book id, title, author last name, author first name, rating) patrons (patron id, last name, first name, street address, city state zip, location) transactions (transaction_id, patron id, book id, transaction_date, transaction_type) + Please note the following codes: transaction code 1 checking out, 2returning 3placing a hold+ Use the existing database to do the following: 1. Adding new columns: Write an SQL statement to add a new columns DOB, LAST MODIFIED and MODIFIED BY columns to the PATRONS table. The LAST MODIFIED column will have the server date and time and the MODIFIED BY will have the USER name. a. 2. Add two patrons with their DOB, LAST-MODIFIED, and MODIFIED-BY +' Write an SQL statement to add two new patrons to the table. Use the TO_DATE function for their DOBs. Use the SEQUENCE to insert patron id. Print the query and the results. + Write and SQL query to list the patrons (patron_id, last_name, first_name, DOB) using the format: Name as Upper case Initial, period, comma, and Last name in a mixed case. Use the ISO standard for DOB (YYYY-MM-DD). Sort the results by last name. Print the query and the results. + a. b. Part 2 SQL queries (1 % Use the modified database from PART 1. 1. Write SQL to list all patrons with their ids and age in years (rounded up). Age is 2. Write SQL to list all patrons and their number of transactions for each transaction type 3. Write SQL to list the books with the word "database" or "data base or "databases" in calculated based on the server date/time. Sort the results by age in an ascending order. + Include all patrons even if they do not have transactions. +' their title. Make your search case insensitive. Print the author's last name (mixed case) and the title. Sort the results by the rating