Based on the four tables that are created in the first question, you should stor

Question

Based on the four tables that are created in the first question, you should store (insert) the following data using SQL statements: Author_ID FIRST_NAME LAST_NAME 111 Ali Sami 222 Mohammed Khalid 333 Saad Ahmed ISBN Author_ID 15111 111 16222 222 17222 222 18111 111 15111 333 ISBN Title Price publisher Pub_date Edition Pages 15111 Math 1 37.99 New Math January 20, 2016 1 256 16222 The Art of Strategy 26.94 AWP June 21, 2014 3 250 17222 Calculus 25 New Math January 11, 2017 1 753 18111 Game Theory 40.99 MIT January 01, 2016 2 333 15111 Graph Theory 100 John Wiley January 01, 2018 1 320 Author (Author_ID, FIRST_NAME, LAST_NAME) Book_authors_books (ISBN, Author_ID) Book_descriptions (ISBN, Title, Price, Publisher, Pub_date, Edition, Pages) Please make sure to type the answer as works not as a photo.

Explanation / Answer

Insert into Author(Author_ID, FIRST_NAME, LAST_NAME) values (111,' Ali', 'Sami')

Insert into Author(Author_ID, FIRST_NAME ,LAST_NAME) values (222,' Mohammed', 'Khalid')

Insert into Author(Author_ID ,FIRST_NAME, LAST_NAME) values (333,'Saad', 'Ahmed')

insert into Book_authors_books (ISBN, Author_ID) values (15111,111)

insert into Book_authors_books (ISBN, Author_ID) values (16222, 222)

insert into Book_authors_books (ISBN, Author_ID) values (17222 ,222)

insert into Book_authors_books (ISBN, Author_ID) values (18111, 111)

insert into Book_authors_books (ISBN, Author_ID) values (15111 ,333)

insert into Book_descriptions (ISBN, Title, Price, Publisher, Pub_date, Edition, Pages) values(15111 ,'Math' , 37.99, 'New Math', 'January 20, 2016', 1,256)

insert into Book_descriptions (ISBN, Title, Price, Publisher, Pub_date, Edition, Pages) values(16222, 'The Art of Strategy', 26.94, 'AWP', 'June 21, 2014', 3, 250)

insert into Book_descriptions (ISBN, Title, Price, Publisher, Pub_date, Edition, Pages) values(17222, 'Calculus', 25, 'New Math', 'January 11, 2017', 1 ,753)

insert into Book_descriptions (ISBN, Title, Price, Publisher, Pub_date, Edition, Pages) values(18111, 'Game Theory', 40.99 'MIT', 'January 01, 2016' ,2, 333)

insert into Book_descriptions (ISBN, Title, Price, Publisher, Pub_date, Edition, Pages) values(15111 ,'Graph Theory', 100, 'John Wiley', 'January 01, 2018', 1, 320)

Do ask if any doubt. Please upvote

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.