Question: please Use Oracle DB instead of SQL 1. Use SQL to Create a table called Book with the following attributes: Default value Column Book_ID Book

please Use Oracle DB instead of SQL

1. Use SQL to Create a table called Book with the following attributes: Default value Column Book_ID Book Name Book_Publish_Date Data Type Number(7) Vachar2(40) Date sysdate . Then Modify the Book Table to make the following changes : Add new column. Borrow_due date Date Add new column Book_number Number( 5) with default value 3Add new column , Book_writer varchar(40) Add New column . Book Status varchar2 (10) Change the size of Book_Name to be varchar2(55) Change the Size of Book_ID to be number (4) Drop the column Book_Status. Rename the Table to be Library instead Drop the Table Book Flashback the table Book

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Lab Exercise 2: C\# .NET 6 Class Library For exercises 24, create a blogging site using ASP.NET Web API and SQL Server Database. The site must have log in, registration, and post functionality...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Database HW1 Suppose you would like to make a database for a book store where you need to keep track of the books and customers who bought the books Specify the entities - 1 .specify for each entity...

Please Use ORACLE SQL In this application, you will be adding/registering an item, updating it, and doing select statements. You get to pick what you are registering. It can be students, employees,...

The question is for introduction to database system with sql live. The assignmemt is due on tomorrow 12p.m. Part 1 Maintaining and redesigning an existing database Create the following schema for...

please help me with this. specially number 4 and 5. this is my first time posting in chegg. i hope someone will help me with this. due date is tonight. Objective: For this assignment, you will use...

please show full activity in EXCEL and answers the individual questions also. will rate good Lab Activities: the saised - Siar Revow adi CREATE A Na W DNIABASE, - Ogear Microsoft Acciev the file...

ORACLE SQL (1) Write and run an ALTER TABLE command to add a column that is of the TIMESTAMP data type to the hold_02 table in your schema. Name the new column the hold_date_ts. (2) Write and run...

solve the second part please Part 1 Maintaining and redesigning an existing database Create the following schema for maintaining the books issued to the patrons. books (book. id int, title...

In the excel please thank you Follow the steps below: 1. Create a new, blank workbook, and then save the workbook as Textbook List, Your Full Name, in the location specified by your instructor (your...

3. [6 marks] Consider Z is defined to be the present value random variable for a n-year endowment policy issued to X with a face amount of $1000. Calculate the variance of Z given the following...

A Paromagnetic gays with L=0, j = S = /299 = 2 Mj = 4/2 MB =927x1024 AMN = 1028 2, (13 o). Obtain expressions for automic densties in enessy levels and resultant magnetization?

A variety of institutional options are available to meet the varying needs of the elderly who no longer can live alone safely. What are some available options today for this population?

Marketing questions 1.Which of the following is NOT considered to be a form of trade sales promotion? a. trainingb. push moneyc. pull moneyd. free merchandise 2.When building long-term relationships,...

LO8.5 Define fairness and give examples of how it affects behavior in the economy and in the dictator and ultimatum games.

6. Suppose that Ike is loss averse. In the morning, Ikes stockbroker calls to tell him that he has gained $1,000 on his stock portfolio. In the evening, his accountant calls to tell him that he owes...

1. Which of the following are systematic errors? LO8.1 a. A colorblind person who repeatedly runs red lights. b. An accountant whose occasional math errors are sometimes on the high side and...