JD Book Shop is planning to develop a new web-based system for its customers to or...

  

Transcribed Image Text:

JD Book Shop is planning to develop a new web-based system for its customers to or books and for staff to manage books. Figure 3 shows the MVC framework with Java clas and files involved, and Figure 4 shows the database design. Model/Bean Books Order View/SP/HTML listBook.jsp Controller/Servlet ListAlBooksController doGet!) Data Access/Data Access Object OrderDAO getAlBooks) Figure 3: MVC Framework Database Design Table: Books book_id Table: Orders (10) order_id int(10) varchar(30) y ordered 10) author varchar(50) varchar(50) price :double cu email varchar(50) cut phone book_id char(12) (10) Figure 4: Database Design a) Create a table for Books and Orders records. Database JD Book Shop is planning to develop a new web-based system for its customers to or books and for staff to manage books. Figure 3 shows the MVC framework with Java clas and files involved, and Figure 4 shows the database design. Model/Bean Books Order View/SP/HTML listBook.jsp Controller/Servlet ListAlBooksController doGet!) Data Access/Data Access Object OrderDAO getAlBooks) Figure 3: MVC Framework Database Design Table: Books book_id Table: Orders (10) order_id int(10) varchar(30) y ordered 10) author varchar(50) varchar(50) price :double cu email varchar(50) cut phone book_id char(12) (10) Figure 4: Database Design a) Create a table for Books and Orders records. Database