BOOK Bookld Title PublisherName BOOK AUTHORS ld Bookld AuthorName a) Create a da
ID: 3827483 • Letter: B
Question
BOOK Bookld Title PublisherName BOOK AUTHORS ld Bookld AuthorName a) Create a database that corresponds to the above schema with tables that include: BOOK, and BOOK AUTHOR. b) Insert following data to the database tables above. Book Id Title Publisher Name The Three Musketeers Dorrance Publishing Co. Inc Identity and Violence The illusion of Destiny Hachette Book Group HarperCollins Publishers The Argumentative Indian Macmillan Publishers Development as Freedom River of Smoke Hachette Book Group Bookld uthor Name 1 Alexander Dumas 2 2 Amartya Sen Amartya Sen 4 4 Amartya Sen 5 5 Amitav Ghose 2 Alexander Dumas c) Develop a HTML program that receives a book title from a user. The HTML program is deployed on a tomcat server and a user can access the HTML program via a URL using a web browser.Explanation / Answer
[1]
CREATE TABLE BOOK
(
BookId INT NOT NULL,
Title VARCHAR(100),
PublisherName VARCHAR(100),
PRIMARY KEY (BookId)
);
CREATE TABLE BOOK_AUTHORS
(
ID INT NOT NULL,
BookId INT,
AuthorName VARCHAR(100),
PRIMARY KEY (ID),
FOREIGN KEY (BookId) REFERENCES BOOK(BookId)
);
==================================================================
[2]
INSERT INTO BOOK VALUES (1,'The Three Musketeers','Dorrance Publishing Co.Inc');
INSERT INTO BOOK VALUES (2,'Identity and Violence : The illusion of density','Hachette Book Group');
INSERT INTO BOOK VALUES (3,'The Argumentative Indian','HarperCollins Publishers');
INSERT INTO BOOK VALUES (4,'Development as Freedom','Macmillan Publishers');
INSERT INTO BOOK VALUES (5,'River of smoke','Hachette Book Group');
INSERT INTO BOOK_AUTHORS VALUES (1,1,'Alexander Dumas');
INSERT INTO BOOK_AUTHORS VALUES (2,2,'Amartya Sen');
INSERT INTO BOOK_AUTHORS VALUES (3,3,'Amartya Sen');
INSERT INTO BOOK_AUTHORS VALUES (4,4,'Amartya Sen');
INSERT INTO BOOK_AUTHORS VALUES (5,5,'Amitav Ghose');
INSERT INTO BOOK_AUTHORS VALUES (6,2,'Alexander Dumas');
=============================================================================
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.