Question: I posted this code in my Sql and keep getting error (5: Unexpected token: DATABASE in statement [create database]) create database mydatabase; create table book(

I posted this code in my Sql and keep getting error (5: Unexpected token: DATABASE in statement [create database])

create database mydatabase; create table book( iSBN_number int primary key, title varchar2(20), author varchar2(20), cost varchar2(10)

)

insert into book values(1441438, 'Alice in Wonderland', 'Lewis Carroll' ,$7.95) insert into book values(6006374,'A First Course in Database Systems (3rd ed.)','Jeffrey Ullman',$99.49) insert into book values(3523323,'Database System Concepts','Abraham Silberschatz',$119.67)

create table bookCopy( iSBN_number int primary key, Sequence int , publicationDate Date )

create table borrower ( librarycard int autoincrement primery key, name varchar2(20), Address varchar2(20), postalcode varchar2(20), pnoneNumber varchar2(10), Membershipdate date )

create table librarian( librarianId int auto primery key, Name varchar2(20), phone varchar2(10), supervisor int )

insert into librarian values(1,'Gertrude Smith','555-1212') insert into librarian values(2,'Mable Markham','555-1212')

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!