Student Database using Shell Programming

 

Write a program to handle student data base with options given below :

a) Create data base.

b) View Data Base.

c) Insert a record.

d) Delete a record.

e) Modify a record.

f) Result of a particular student.

g) Exit.

Student Database using Shell Programming Code

 

 clear  
 echo "1. create database "  
 echo "2. view database "  
 echo "3. insert a record "  
 echo "4. delete record "  
 echo "5. modify a record "  
 echo "6. result of particular student "  
 echo "7. exit"  
 echo " enter ur choice "  
 read d  
 case $d in  
 1)  
    echo " enter rollnumber of student "  
   read rn  
   echo " enter name of student "  
   read nm  
   echo " enter marks sanskrit "  
   read sk  
   echo " enter marks english "  
   read eg  
   echo " enter marks hindi "  
   read hn  
   record="$rn $nm $sk $eg $hn "  
   echo $record>stud   
   ;;  
 2) echo " showing database of student"  
   cat stud ;;  
 3)   
   echo " enter rollnumber of student "  
   read rn  
   echo " enter name of student "  
   read nm  
   echo " enter marks sanskrit "  
   read sk  
   echo " enter marks english "  
   read eg  
   echo " enter marks hindi "  
   read hn  
   record="$rn $nm $sk $eg $hn "  
   echo $record>>stud  
    ;;  
 4) echo " enter roll number "  
   read rn  
   grep ^$rn stud  
   if [ $? -ne 0 ]; then  
   echo "record for roll number does not exist "  
   else  
   grep -v $rn stud>>tmp  
   cp tmp stud  
   echo "deletion complete "  
   fi  
   ;;  
 5) echo " enter roll number "  
   read rn1  
   grep ^$rn stud  
   if [ $? -ne 0 ]; then  
   echo "record for roll number does not exist "  
   else  
   echo " enter roll number "  
   read rn  
   echo " enter name of student "  
   read nm  
   echo " enter marks sanskrit "  
   read sk  
   echo " enter marks english "  
   read eg  
   echo " enter marks hindi "  
   read hn  
   record="$rn $nm $sk $eg $hn "  
   var=`grep -n ^$rn1 stud | cut -c 1`  
   echo $var  
   var1=`expr $var - 1`  
   head -$var1 stud>temp  
   echo $record>>temp  
   var3=`wc -l < stud`  
   var2=`expr $var3 - $var `  
   tail -$var2 stud>>temp  
   cp temp stud  
    fi  
 ;;  
 6) echo " enter roll number "  
   read rn  
   echo "printing result "  
   grep ^$rn stud  
 ;;  
 7) ;;  
 * ) echo "enter right choice"  
 esac