Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Pro Blog
  • Users
  • Groups
  • Unsolved
  • Solved
Collapse
Secnto AI
  1. Secnto AI
  2. Categories
  3. Virtual University
  4. CS406 - Web Based Database Applications
  5. CS406 Assignment 2 Solution and Discussion
CS406 Assignment 1 Solution and Discussion
M
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.
CS406 - Web Based Database Applications
CS406 Assignment 3 Solution and Discussion
zareenZ
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.
CS406 - Web Based Database Applications
CS406 Assignment 2 Solution and Discussion
zareenZ
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 - Web Based Database Applications
CS406 Assignment 1 Solution and Discussion
zaasmiZ
Topic thumbnail image
CS406 - Web Based Database Applications

CS406 Assignment 2 Solution and Discussion

Scheduled Pinned Locked Moved Solved CS406 - Web Based Database Applications
cs406assignment 2solutiondiscussionfall 2019
2 Posts 1 Posters 509 Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • zareenZ Offline
    zareenZ Offline
    zareen
    Cyberian's Gold
    wrote on last edited by
    #1

    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.

    1. The title “Assignment No 2” should be on the top of the page.
    2. The border size of the table should be 1.
    3. There should be 3 Columns and 10 Rows.
    4. 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.
    5. 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:
    8d912334-2a82-4525-8025-1c32099f2827-image.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.

    Discussion is right way to get Solution of the every assignment, Quiz and GDB.
    We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
    Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
    %(red)[NOTE: Don't copy or replicating idea solutions.]
    Quiz Copy Solution
    Mid and Final Past Papers
    Live Chat

    1 Reply Last reply
    0
    • zareenZ Offline
      zareenZ Offline
      zareen
      Cyberian's Gold
      wrote on last edited by
      #2

      @zareen said in CS406 Assignment 2 Solution and Discussion:

      Write a program in PHP using for loop and embed it in HTML.

      https://www.youtube.com/watch?v=Zhy7UHUwBKE

      Discussion is right way to get Solution of the every assignment, Quiz and GDB.
      We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
      Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
      %(red)[NOTE: Don't copy or replicating idea solutions.]
      Quiz Copy Solution
      Mid and Final Past Papers
      Live Chat

      1 Reply Last reply
      0

      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      How to Build a $1,000/Month PAK VS BAN Live Live Cricket Streaming
      File Sharing
      Earn with File Sharing

      1

      Online

      3.0k

      Users

      2.8k

      Topics

      8.2k

      Posts
      solution
      1235
      discussion
      1195
      fall 2019
      813
      assignment 1
      428
      assignment 2
      294
      spring 2020
      265
      gdb 1
      238
      assignment 3
      79
      • PM. IMRAN KHAN
        undefined
        4
        1
        4.0k

      • Are the vaccines halal or not?
        undefined
        4
        1
        3.8k

      • All Subjects MidTerm and Final Term Solved Paper Links Attached Please check moaaz past papers
        zaasmiZ
        zaasmi
        3
        26
        75.1k

      • CS614 GDB Solution and Discussion
        M
        moaaz
        3
        3
        8.1k

      • How can I receive Reputation earning from Cyberian? 100% Discount on Fee
        Y
        ygytyh
        3
        28
        23.9k
      | |
      Copyright © 2010-26 RUP Technologies LLC. USA | Contributors
      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • Pro Blog
      • Users
      • Groups
      • Unsolved
      • Solved