CS406 - Web Based Database Applications

Re: CS406 Assignment 1 Solution and Discussion Assignment No. 01 Semester: Spring 2020 CS406 – Web Based Database Applications Total Marks: 10 Due Date: 05-Jun-2020 Assignment Submission Instructions: Please read the following instructions carefully before submitting assignment: It should be clear that your assignment will not get any credit if: • Assignment is submitted after due date. • Submitted assignment does not open or file is corrupt. • Assignment is copied (From internet or from other students). • You must submit assignment only in .html or htm format, and you must keep all your files in a single folder and zip the folder to upload .zip or .rar file on LMS. Lectures Covered: Week 01 to Week 03 Lectures have been covered. Objectives: The purpose of this assignment is to make you familiar with following topics: • HTML tags, Table in HTML, HTML form Question Marks: 10 You are required to develop an HTML page using Microsoft Notepad named as Student Profile Form. It will contain basic HTML controls and form. The required output is as follows; Required Output: [image: dGuZETX.png] Deadline: Your assignment must be uploaded on or before the given due date. We shall not accept your solution through email after the due date.

Assignment No. 03 Fall 2019 CS406 – Web Based Database Applications Total Marks: 20 Due Date: 24-Jan-2020 Assignment Submission Instructions: Please read the following instructions carefully before submitting assignment: It should be clear that your assignment will not get any credit if: o Assignment is submitted after due date. o Submitted assignment does not open or file is corrupt. o Assignment is copied (From internet/ to from students). o You must submit assignment only in .sql or .txt or zipped format on VULMS. Objectives: The purpose of this assignment is to make you familiar with following topics: • MySQL Overview, Introduction, Installation, Configuration Steps • MySQL-Structure (RDBMS , Creating Table for web application, Data Types) • Insert, Update, Delete, Connecting to MySQL using a client such as PHP MyAdmin or MySQL Workbench Instructions: You have to use phpmyadmin GUI tool to design database and tables, also create relations and then export complete schema and submit your exported .sql file on LMS. Assignment 20 marks Consider the “HR database” structures given below and write the following queries. [image: RAQUML1.png]  Write a query to select FIRST_NAME from employees table without duplications. (5 Marks)  Write a query to select top 5 rows from employees table where salary is less than or equal to 5000. (5 Marks)  Write a query to find employees with null hire_date from employees table. (5 Marks)  Write a query to select all employees starting last_name with “M”. (5 Marks) Deadline: Your assignment must be uploaded on or before the given dye date. We shall not accept your solution through email after the due date.

Assignment No. 02 Fall 2019 CS406 – Web Based Database Applications Total Marks: 20 Due Date: 05-Dec-2019 Assignment Submission Instructions: Please read the following instructions carefully before submitting assignment: It should be clear that your assignment will not get any credit if: o Assignment is submitted after due date. o Submitted assignment does not open or file is corrupt. o Assignment is copied (From internet/ to from students). o You must submit assignment only in .php format, and you must keep all your files in a single folder and zip the folder to upload .zip or .rar file on LMS. Lectures Covered: Week 4, Week 5 and Week 6 Lectures have been covered. Objectives: The purpose of this assignment is to make you familiar with following topics: • PHP Syntax, Data Types, Variables and Variables scope • PHP Functions and Controls, Functions, Control Structures, Loops, Arrays • Embedded PHP, Embedded PHP in HTML 5, Strings in PHP Assignment Marks: 12+8 Question 1: Write a program in PHP using for loop and embed it in HTML. The title “Assignment No 2” should be on the top of the page. The border size of the table should be 1. There should be 3 Columns and 10 Rows. Create 2 arrays, one for Order Quantity and One for Unit price and then multiply Order quantity with Unit price and show it result in 3rd column. You will use a single loop to print the values of arrays and the result. Hint: You can also embed html tags in PHP code. Sample Out Put: [image: 2d4OLtq.png] Question 2: Write a function (totalWords) in PHP which will receive two strings. After receiving the strings it will find total words in each string individually using built-in function str_word_count() and then it will return the total words of both the strings and then print the total words on the screen. For example : String 1= “Virtual University of Pakistan” String 2= “Federal Government University” Total Words = 7 Deadline: Your assignment must be uploaded on or before the given due date. We shall not accept your solution through email after the due date.