Question: I need help with this database creation. Create a database and call it csci2006. Use the following command: create database csci2006; Create a table and

I need help with this database creation.

Create a database and call it csci2006. Use the following command:

create database csci2006;

Create a table and call it books. Use the following command:

create table books (isbn int not null primary key, title varchar(255), edition int, copyright varchar(255));

Create a table and call it author using the following command:

create table author (authorId int not null primary key, firstName varchar(255), lastName varchar(255));

Add five records to each table.

Here is an example of how to insert a record into books table:

insert into books (isbn, title, edition, copyright) values (234, Java, 3, 2011);

What will be the result of the following queries?

select * from books;

select title from books;

select edition, copyright from books;

select * from books where title=Java;

select * from books where isbn > 234;

update books set title=javaScript Where isbn = 234;

delete from books where isbn=234;

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!