Ready Project |BCA Project | MCA Project | BBA Project | MBA Project |INDIA'S BIGGEST COLLEGE PROJECT STORE

20)Consider the following entities and their relationships
Emp (emp_no,emp_name,address,phone,salary)
Dept (dept_no,dept_name,location)
Emp-Dept are related with one-many relationship
Create a RDB in 3NF for the above and solve following
Using above database write a PHP script which will
a) Insert employee records in table .
b) Print a salary statement in the format given below, for a given department. (Accept department name from the user).

Maximum Salary Minimum Salary Sum Salary


                     Html file -


<html>

<body>

<form action="slip_20.php" method="get">


<center><h2>Fill Employee Details : </h2>

<table>

<tr><td>Enter Employee No :</td>       <td><input type=text name=e_no></td>           </tr>

<tr>  <td>Enter Employee Name :</td>    <td><input type=text name=e_nm></td>    </tr>

<tr> <td>Enter Address :</td>                 <td><input type=text name=add></td>      </tr>

<tr><td>Enter Phone :</td>                     <td><input type=text name=ph></td>        </tr>

<tr>  <td>Enter Salary :</td>                     <td><input type=text name=sal></td>        </tr>

<tr> <td>Enter Department no :</td>       <td><input type=text name=d_no></td>     </tr>

<tr> <td>Enter Department name :</td>  <td><input type=text name=d_nm></td>    </tr>

<tr>  <td>Enter Location :</td>                  <td><input type=text name=loc></td>        </tr>

<tr>  <td></td>                                          <td><input type=submit value=OK></td>   </tr>

</table>

</center>


</form>

</body>

</html>



Php file -


<?php

            $e_no   =   $_GET['e_no'];

            $e_name   =   $_GET['e_nm'];

            $add   =   $_GET['add'];

            $ph   =   $_GET['ph'];

            $sal   =   $_GET['sal'];

            $d_no   =   $_GET['d_no'];

            $d_nm   =   $_GET['d_nm'];

            $loc   =   $_GET['loc'];

           
            $con    =    mysql_connect("localhost","root","");  
  
            $d    =    mysql_select_db("bca_programs",$con);  


              $q   =   mysql_query("insert into emp values($e_no,'$e_name','$add',$ph,$sal)");  

            $q1   =   mysql_query("insert into dept values($d_no,'$d_nm','$loc',$e_no)");

            $q2   =   mysql_query("select MIN(salary),MAX(salary),SUM(salary) from emp,dept where emp.emp_no=dept.emp_no");


            echo "<tr><td>Minimum salary----</td><td>Maximum salary----</td><td>Sum of Salary</td></tr>";


            while($row  =  mysql_fetch_array($q2))

            {
                        echo "<tr><td>".MIN(salary)."</td><td>".MAX(salary)."</td><td>".SUM(salary)."</td></tr>";

            }


            mysql_close();

?>

Search

Project Categories

Recent Posts

Sign In