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.
CS406 Assignment 1 Solution and Discussion
-
Re: CS406 Assignment 1 Solution and Discussion
Assignment No. 01
Semester: Spring 2020
CS406 – Web Based Database Applications Total Marks: 10Due 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: 10You 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:
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.
-
<html> <title></title> <body> <h1><U>Student Profile Form</U></h1></div> <form action="form.php" method="POST"> <table> <tr> <td width="50%">Student ID </td> <td width="50%"><INPUT TYPE = "text" NAME="sID"></td> </tr> <tr> <td width="50%">Form No </td> <td width="50%"><INPUT TYPE = "Number" NAME="fNO"></td> </tr> <tr> <td width="50%">Name</td> <td width="50%"><INPUT TYPE = "text" NAME="sName" ></td> </tr> <tr> <td width="50%">Current Semester</td> <td width="50%"><INPUT TYPE = "text" NAME="cSem"></td> </tr> <tr> <td width="50%">CGPA</td> <td width="50%"> <INPUT TYPE = "Number" NAME="sCGPA"></td> </tr> <tr> <td width="50%">Entery Test Qualified</td> <td width="50%"><input type="radio" name="ETQ"> Yes <input type="radio" name="ETQ"> No</td> </tr> <tr> <td width="50%">Study Program</td> <td width="50%"><select name="SP" id="SP"> <option value="bs">Please Select</option> <option value="bs">BSCS</option> <option value="mc">MCS</option> <option value="ms">MSCS</option> </select> </td> </tr> <tr> <td width="50%">VU Email</td> <td width="50%"><INPUT TYPE = "Text" NAME="emAddress"></td> </tr> <tr> <td width="50%">Mobile No</td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> </tr> <tr> <td width="50%">Address</td> <td width="50%"><INPUT TYPE = "Text" NAME="sAddress"></td> </tr> <table> <thead> <tr> <th rowspan="5">Academic Qualifications</th> <th>Certificate/Degree Name</th> <th>Name of Institute</th> <th>Registration Number</th> <th>Obtained Marks/CGPA</th> <th>Total Marks/CGPA</th> </tr> <tr> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> </tr> <tr> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> </tr> <tr> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> </tr> <tr> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> <td width="50%"> <INPUT TYPE = "Number" NAME="sMob"></td> </tr> </thead> </table> <tr> <table> <tr> <td align="center"></td> <td style="text-align:center" width="50%"><INPUT TYPE = "submit" NAME="Submit"></td> <td align="center"></td> <td style="text-align:center" width="50%"><INPUT TYPE = "reset" NAME="Reset"></td> </tr> </table> </form> </body> </html>Output
PAK VS BAN Live
File Sharing
