You have recently been hired to create an inventory management system for “Book Hub”, a new online bookstore of the company in your area. The stock is currently being tracked using a paper system and a excel spreadsheet. Write an SQL script to create a table called books in a database called Bookhub, with the following fields: • Book_id, which is the primary key and value is provided by the database server. • Title, which has an appropriate string format • Author, which has an appropriate string format. • Year, which has a whole number format. • Price, which is the price of purchase of the book. After creating a table which will store values. Use the books table to write a web page (php) that connects to the database (Bookhub) and executes a query on the table to get all the table data stored in a table and then display them information on using an HTML table format.
1.1. You have recently been hired to create an inventory management system for “Book
Hub”, a new online bookstore of the company in your area. The stock is currently
being tracked using a paper system and a excel spreadsheet. Write an SQL script to
create a table called books in a
• Book_id, which is the primary key and value is provided by the database server.
• Title, which has an appropriate string format
• Author, which has an appropriate string format.
• Year, which has a whole number format.
• Price, which is the price of purchase of the book.
After creating a table which will store values. Use the books table to write a web page (php)
that connects to the database (Bookhub) and executes a query on the table to get all the
table data stored in a table and then display them information on using an HTML table format.
[18 ]
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 5 images
