Given is a database schema for a library management system BOOK Bookld Title Pub
ID: 3823209 • Letter: G
Question
Given is a database schema for a library management system
BOOK Bookld Title PublisherName BOOK AUTHORS Jd 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. Bookld Title PublisherName 1 The Three Musketeers Dorrance Publishing Co. Inc 2 Hachette Book Group Identity and Violence :The illusion of Destiny The Argumentative Indian HarperCollins Publishers Development as Freedom Macmillan Publishers S River of Smoke Hachette Book Group TAuthorName Bookld Alexander Dumas 2 2 Amartya Sen Amartya Sen Amartya Sen 4 S 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
create table Book(Bookid int primary key,Title varchar(20),PublisherName varchar(20));
mysql> desc book;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| Bookid | int(11) | NO | PRI | NULL | |
| Title | varchar(20) | YES | | NULL | |
| PublisherName | varchar(20) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-----
create table Book_Authors(id int primary key,Bookid int references Book,AuthorName varchar(20));
desc Book_Authors;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id | int(11) | NO | PRI | NULL | |
| Bookid | int(11) | YES | | NULL | |
| AuthorName | varchar(20) | YES | | NULL | |
insert into Book values(1,'the three musketeers','Dorrance Publishing Co.inc');
mysql> insert into Book values(2,'Identity and Violence:Theillusion of Density','Hachette Book Group');
mysql> insert into Book values(3,'The Argumentative Indian','HarperCollins Publishers');
mysql> insert into Book values(4,'Development as Freedom','Macmillan Publishers');
mysql> insert into Book values(5,'River of Smoke','Hachette Book Group');
mysql> select * from Book;
+--------+----------------------+----------------------+
| Bookid | Title | PublisherName |
+--------+----------------------+----------------------+
| 1 | the three musketeers | Dorrance Publishing |
| 2 | Identity and Violenc | Hachette Book Group |
| 3 | The Argumentative In | HarperCollins Publis |
| 4 | Development as Freed | Macmillan Publishers |
| 5 | River of Smoke | Hachette Book Group |
+--------+----------------------+----------------------+
insert into Book_Authors values(1,1,'Alexander Dumas');
mysql> insert into Book_Authors values(2,2,'Amartya Sen');
mysql> insert into Book_Authors values(3,3,'Amartya Sen');
mysql> insert into Book_Authors values(4,4,'Amartya Sen');
mysql> insert into Book_Authors values(5,5,'Amitav Ghose');
mysql> insert into Book_Authors values(6,2,'Alexander Dumas');
mysql> select * from Book_Authors;
+----+--------+-----------------+
| id | Bookid | AuthorName |
+----+--------+-----------------+
| 1 | 1 | Alexander Dumas |
| 2 | 2 | Amartya Sen |
| 3 | 3 | Amartya Sen |
| 4 | 4 | Amartya Sen |
| 5 | 5 | Amitav Ghose |
| 6 | 2 | Alexander Dumas |
+----+--------+-----------------+
Demo.html
<HTML>
<HEAD>
<TITLE>Book Info</TITLE>
</HEAD>
<BODY BGCOLOR="#FDF5E6">
<CENTER>
<H2>Book Info Page</H2>
<FORM ACTION="">
Book Title:
<INPUT TYPE="TEXT" NAME="Book Title"><BR>
<P>
<INPUT TYPE="SUBMIT" Value="SUBMIT">
</FORM>
</CENTER>
</BODY></HTML>
the html Program is deployed on tomcat server and a user can access the HTML program via URL using a web browserProgram is deployed on tomcat server and a user can access the HTML program via URL using a web browser
<HTML>
<HEAD>
<TITLE>A Sample Form Using GET</TITLE>
</HEAD>
<BODY BGCOLOR="#FDF5E6">
<CENTER>
<H2>A Sample Form Using GET</H2>
<FORM ACTION="http://localhost:8088/SomeProgram">
First name:
<INPUT TYPE="TEXT" NAME="firstName" VALUE="Joe"><BR>
Last name:
<INPUT TYPE="TEXT" NAME="lastName" VALUE="Hacker"><P>
<INPUT TYPE="SUBMIT"> <!-- Press this button to submit form -->
</FORM>
</CENTER>
</BODY></HTML>
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.