SQL

 <!DOCTYPE>

<html>

<head>

    <title>Fruit Cost Calculator</title>

    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

    <script type="text/javascript">

    /* <![CDATA[ */

        var total = 0.0;

        function updateTotal(price, checkbox) {

            if (checkbox.checked) {

                total += price;

            } else {

                total -= price;

            }

            document.getElementById("runningTotal").value = total.toFixed(2);

        }

        function submitOrder() {

            var taxRate = 0.05;

            var finalTotal = total + (total * taxRate);

            alert("Your total cost is $" + finalTotal.toFixed(2));

            return false; // Prevent form submission

        }

    /* ]]> */

    </script>

</head>

<body>

    <h2>Fruit Selection</h2>

    <form action="#" method="post" onsubmit="return submitOrder();">

        <p>

            <input type="checkbox" id="apple"

                   onclick="updateTotal(0.59, this)" />

            <label for="apple">Apple ($0.59 each)</label>

        </p>

        <p>

            <input type="checkbox" id="orange"

                   onclick="updateTotal(0.49, this)" />

            <label for="orange">Orange ($0.49 each)</label>

        </p>

        <p>

            <input type="checkbox" id="banana"

                   onclick="updateTotal(0.39, this)" />

            <label for="banana">Banana ($0.39 each)</label>

        </p>

        <p>

            Running Total (before tax): $

            <input type="text" id="runningTotal" value="0.00" readonly="readonly" />

        </p>

        <p>

            <input type="submit" value="Submit Order" />

        </p>

    </form>

</body>

</html>

[24/02, 8:45 am] Soham BCA: <!DOCTYPE html>

<html>

<head>

    <title>Lab Program 3 - Paragraph/Title</title>

   <style type="text/css">

        .content {

            position: relative;

            width: 400px;

            height: 250px;

            border: 1px solid gray;

        }

        .para {

            position: absolute;

            width: 380px;

            height: 150px;

            padding: 10px;

            border: 1px solid black;

            background-color: skyblue;

            overflow: hidden;

            cursor: pointer;

        }

        #p1 { top: 0px; z-index: 1; }

        #p2 { top: 30px; z-index: 2; }

        #p3 { top: 60px; z-index: 3; }

    </style>

    <script type="text/javascript">

        function bringToTop(id) {

            document.getElementById(id).style.zIndex = 10;

        }

        function restorePosition(id, originalZ) {

            document.getElementById(id).style.zIndex = originalZ;

        }

    </script>

</head>

<body>

    <h2>Hover on a Paragraph</h2>

    <div class="content">

        <div id="p1" class="para"

             onmouseover="bringToTop('p1')"

             onmouseout="restorePosition('p1',1)">

            <p>

                "It Ain't Over Til It's Over."

                <br><b>– DARSHAN</b>

            </p>

        </div>

        <div id="p2" class="para"

             onmouseover="bringToTop('p2')"

             onmouseout="restorePosition('p2',2)">

            <p>

                "A Clear Rejection Is Always Better Than Fake Promises."

            </p>

        </div>

        <div id="p3" class="para"

             onmouseover="bringToTop('p3')"

             onmouseout="restorePosition('p3',3)">

            <p>

                <b>Secret of Mind</b><br>

                I Walk Alone Because I Trust My Shadow more Than People's Fake Smile.<br>

            </p>

        </div>

 </div>

</body>

</html>






SQL> CREATE TABLE TOURIST_PLACE(TPID VARCHAR(10)

          PRIMARY KEY,TPNAM VARCHAR(10),STATE VARCHAR(10),

          HISTORY VARCHAR(10),KM NUMBER(5));

Table created.

SQL> INSERT INTO TOURIST_PLACE

  2 VALUES('TP01','NANDI','KARNATAKA','HILLS',50);

  SQL> INSERT INTO TOURIST_PLACE

  2 VALUES('TP02','ISKON','KARNATAKA','TEMPLE',10);





SQL> CREATE TABLE VISIT(TID VARCHAR(10),TPID VARCHAR(10),VDATE

  2 VARCHAR(10),FOREIGN KEY(TID) REFERENCES TOURIST(TID),FOREIGN

  3 KEY(TPID) REFERENCES TOURIST_PLACE(TPID));





SQL> SELECT STATE,COUNT(STATE) AS TOTAL FROM TOURIST_PLACE GROUP BY

  2 STATE HAVING COUNT(TPID) IN (SELECT MAX(COUNT(STATE)) FROM

  3 TOURIST_PLACE GROUP BY STATE);






SQL> SELECT * FROM TOURIST_PLACE WHERE TPID IN(SELECT V.TPID FROM

  2 TOURIST T,VISIT V WHERE T.TID=V.TID GROUP BY V.TPID HAVING

  3 COUNT(V.TPID)IN (SELECT MAX(COUNT(TPID))FROM VISIT GROUP BY TPID));





SQL> SELECT * FROM TOURIST WHERE TID IN(SELECT TID FROM VISIT V JOIN

  2 TOURIST_PLACE TP ON V.TPID=TP.TPID WHERE TP.STATE='KARNATAKA'

  3 GROUP BY TID HAVING COUNT(STATE) IN (SELECT COUNT(STATE) FROM

  4 TOURIST_PLACE WHERE STATE='KARNATAKA'));





SELECT * FROM TOURIST WHERE TID IN(SELECT TID FROM VISIT WHERE TPID IN(SELECT TPID FROM TOURIST_PLACE WHERE STATE='KARNATAKA')GROUP BY TID

  2 HAVING COUNT(DISTINCT TPID)=(SELECT COUNT(*) FROM TOURIST_PLACE WHERE STATE='KARNATAKA'));

Comments

Post a Comment

Popular posts from this blog

Abhijit_python

PART -A Program 1: Check whether the number is belongs to Fibonacci series or not. n=int(input("Enter a number:")) c=0 a=1 b=1 if n==0 or n==1: print("yes,It is Fibonacci Number") else: while c<n: c=a+b b=a a=c if c==n: print("Yes,{0} is fibonacci number".format(n)) else: print("No,{0} is not fibonacci number".format(n)) =========OUTPUT======== Ex:1 Enter a number:5 Yes,5 is fibonacci number Ex:2 Enter a number:4 No,4 is not fibonacci number   Program 2: Solve Quadratic Equations import cmath a=int(input("Enter value for a:")) b=int(input("Enter value for b:")) c=int(input("Enter value for c:")) d=(b**2)-(4*a*c) sol1=(-b-cmath.sqrt(d))/(2*a) sol2=(-b+cmath.sqrt(d))/(2*a) print("the solution are:\n",sol1,"and",sol2) =========OUTPUT======== Enter value for a:5 Enter value for b:10 Enter value for c:15 the solution are: (-1-1.4142135623730951j) and (-1+1.4142135623730951j)   Program 3:Find the sum...
Read more

Php

 1.prime   < html >     < style >         body {             background-color : lightblue ;                 }     </ style > <?php function isPrime ( $n ) {     if ( $n <= 1 )         return false ;     for ( $i = 2 ; $i <= sqrt ( $n ); $i ++)     {         if ( $n % $i == 0 )             return false ;     }     return true ; } $start = 3 ; $end = 20 ; $count = 0 ; for ( $i = $start ; $i <= $end ; $i ++) {     if ( isPrime ( $i ))     {         echo " $i \t " ;         $count ++;     } } echo " <br>The Total number of Prime numbers are = $count " ; ? > </ html > 2)Messgeg Passing    < html >     ...
Read more

Abhijit HTML

 MultimediaAndAnimation  SECTION A  ProgramNo.1:Program to Design LOG IN Form in Html.  <!DOCTYPEhtml>  <html>  <head>  <metaname="viewpoint"content="width"=device width, initial-scale="1">  <title> Login Page</title>  </head>  <body>  <center><h1>StudentLogin Form</h1></center>  <form><center>  <divclass="container">  <lable>username:</lable>  <inputtype="text" place holder="entertheusername" name="username"requried></div><div>  <lable>password:</lable>  <inputtype="password"placeholder="enter password" name="password"requried></div><BR/>  <button type="submit">login</button>  <inputtype="checkbox" checked="checked"> Rememberme  <buttontype="button"class="Canclebtn">...
Read more