Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Main Memory Database Systems

Authors: Frans Faerber, Alfons Kemper, Per-Åke Alfons

1st Edition

1680833243, 978-1680833249

Students also viewed these Databases questions

Question

In an Excel Pivot Table, how is a Fact/Measure Column repeated?

Answered: 1 week ago