Navigation

    Cyberian
    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Pro Blog
    • Users
    • Groups
    • Unsolved
    • Solved
    Quiz 100% Result
    • 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:

      ce934d3e-fb5f-499b-857f-61e8ccf270e2-image.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

      zareen
      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.
      e7d255f2-774b-4fca-a699-a298c8f24789-image.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

      zareen

      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:
      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.

      CS406 - Web Based Database Applications
    • CS406 Assignment 1 Solution and Discussion

      zaasmi

      ff82609f-b30f-4180-9573-ddf844aa906d-image.png Assignment No. 1
      Fall 2019
      CS406 – Web Based Database Applications Total Marks: 20

      Due Date: 15-Nov-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 or from other students).
      o You must submit assignment only in html web pages form, and you must keep all your web pages in a folder and zip the folder to upload .zip or .rar file on LMS.

      Lectures Covered:

      Week 1, Week 2, and Week 3 Lectures have been covered.

      Objectives:
      The purpose of this assignment is to make you familiar with following topics:

      • Introduction to HTML
      • HTML tags
      • Table in HTML
      • HTML form
      Assignment Marks: 10

      You are required to develop an HTML page using Microsoft Notepad named as Patient Admit Form. It will be containing basic HTML controls and form elements. The sample is as follows;

      Sample Output:

      (See next page)

      fdad9dbc-66fb-40e8-a537-adfb9a9dd0be-image.png

      Deadline: Your assignment must be uploaded on or before the due date. We shall not accept your solution through email after the due date.

      CS406 - Web Based Database Applications

    SOLVED CS406 Assignment 2 Solution and Discussion

    CS406 - Web Based Database Applications
    assignment 2 cs406 discussion fall 2019 solution
    1
    2
    8
    Loading More Posts
    • 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.
    • zareen
      zareen Cyberian's Gold last edited by

      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.

      1 Reply Last reply Reply Quote 0
      • zareen
        zareen Cyberian's Gold last edited by

        @zareen said in CS406 Assignment 2 Solution and Discussion:

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

        1 Reply Last reply Reply Quote 0
        • First post
          Last post

        50% Off on Your FEE Join US!

        Quiz 100% Result If you want to know how you can join us and get 50% Discout on your FEE ask Cyberian in Chat Room! Quiz 100% Result Quiz 100% Result
        solution1241 discussion1193 fall 2019813 assignment 1425 assignment 2295 spring 2020265 gdb 1246 assignment 382 crw10174 spring 201955
        | |
        Copyright © 2021 Cyberian Inc. Pakistan | Contributors
        Live Chat