Question 1 to Question 8 will be implemented by XHTML.
Q1.
Q2.
Q3.
Q4.
Q5.
Q6.
Q7.
Q8.
Q9. A list of information about services of an e-commerce company given below. Write SQL Query to
create the table, insert information on the table and show information of the table.
Serial ServiceName Expense UserFeedbackRating
1. Saintmartin Tour 6550.00 4
2. House rent search 1520.00 3
Q10. Create a website registration form using php to obtain a user’s first name, last name and e-mail
address. In addition, include an optional survey question that asks the user’s year in college (e.g.,
Freshman). Show the submitted data in different page.
Q11. A list of information about services of an e-commerce company given below. Write SQL Query
to create the table, insert information on the table and show information of the table in a web page
using php.
Serial ServiceName Expense UserFeedbackRating
1. Saintmartin Tour 6550.00 4
2. House rent search 1520.00 3
Q12. Create a website registration form using php to obtain a user’s first name, last name and e-mail
address. In addition, include an optional survey question that asks the user’s year in college (e.g.,
Freshman). Insert the submitted data in database using php.
Q13. A list of information about services of an e-commerce company given below. Write SQL Query
to create the table, insert information on the table and show information of the table in a web page
using php.
Serial CustomerName Age Gender
1. Rahim Uddin 28 Male
2. Maria Mantasha 23 Female
[Link] an XML and corresponding JSON document to store information about patients in a hospital.
Information about patients must include Name, Age, Address, Patient id, Test Information. Test
information includes Test Name and Test charge of minimum three tests of patient. Prepare data for the
given information.
Sample Data 1: Ajit is a patient of aged 35 lived in 309, Mirpur-10. His patient id is PT3154. One of his test
is CBC (500/-), another is MRI (3000/-) and the last one is a Blood Culture (900/-) test.
Sample Data 2: Sabbir is a patient of aged 55 lived in Santosh, Tangail. His patient id is PT4154. One of his
test is CT Scan (3500/-), another is FT3 (300/-) and the last one is a Urine Culture (800/-) test.
Q15. Create an XML document that marks up the nutrition facts for a package of Grandma White’s
cookies. A package of cookies has a serving size of 1 package and the following nutritional value
per serving: 260 calories, 100 fat calories, 11 grams of fat, 2 grams of saturated fat, 5 milligrams
of cholesterol, 210 milligrams of sodium, 36 grams of total carbohydrates, 2 grams of fiber, 15
grams of sugars and 5 grams of protein. [Hint: Your markup should contain elements describing
the product name, serving size/amount, calories, sodium, cholesterol, proteins, etc. Mark up each
nutrition fact/ingredient listed above.]
Q16. Create three div elements of varying colors, each with a width and height of 200px. On the
first box, add a dimgrey box-shadow with a horizontal offset of 15px, a vertical offset of 15px and
a blur radius of 20px. On the second box, add a blue box-shadow with a horizontal offset of -15px,
a vertical offset of -15px and a blur radius of 30px. On the third box, add a red box-shadow with
a horizontal offset of 15px, a vertical offset of 15px and a blur radius of 10px.
Q17. Write a JavaScript program to calculate multiplication and division of two numbers (input
from user).
Q18. Write a PHP regular expression pattern that matches a string that satisfies the following
description: The string must begin with the (uppercase) letter A. Any three alphanumeric
characters must follow. After these, the letter B (uppercase or lowercase) must be repeated one or
more times, and the string must end with two digits.