To manage(add/update/view/delete) Judge database with Fields: JudgeName, courtname, city, cases_ judged and totalcasses using Linux shell script in Ubuntu
echo enter choice
echo "1.insert"
echo "2.view"
echo "3.count"
echo "4.search"
echo "5.delete"
echo "6.update"
echo "7.display jugdeg name"
echo "8.display higest cases judged"
read choice
case $choice in
1)echo "enter judge name:-"
read jname
echo "enter court name:-"
read cname
echo "enter city:-"
read city
echo "enter number of case judged:-"
read cases_judge
echo "enter total number of cases:-"
read total_cases
echo $jname"|"$cname"|"$city"|"$cases_judge"|"$total_cases >> record_data.txt
echo "data insert successfully";;
2)cat record_data.txt;;
3)cat record_data.txt | wc -l;;
4)echo "enter judge name:-"
read jname
grep -i $jname record_data.txt;;
5)echo "enter judge name:-"
read jname
grep -v "$jname" record_data.txt>record_data1.txt
cp record_data1.txt record_data.txt
echo "Record deleted successfully";;
6)echo "enter judge name:-"
read jname
grep -v "$jname" record_data.txt>record_data1.txt
cp record_data1.txt record_data.txt
echo "enter judge name:-"
read jname
echo "enter count name:-"
read cname
echo "enter city:-"
read city
echo "enter number of cases judged:-"
read cases_judged
echo "enter total number of cases:-"
read total_cases
echo $jname"|"$cname"|"$city"|"$cases_judged"|"$total_cases>>record_data.txt
echo "Data updated successfully";;
7)awk -F "|" '{print $1}' record_data.txt;;
8)awk -F "|" -v max=0 '{if($5>max){content=$0;max=$5}}END{print content}' record_data.txt;;
esac