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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started