Friday, 11 March 2022

Create the following student table and answer the following queries.

 

Table: Student

No

Name

Age

Dept

DateofAdm

Fee

Gender

1

Pankaj

24

Computer

10/01/99

12000

M

2

Shalini

21

History

24/03/20

20000

F

3

Sanjay

22

Hindi

12/12/21

30000

M

4

Sudha

24

History

01/07/21

25000

F

5

Rakesh

22

Computer

27/12/21

30000

M

6

Shakeel

20

Hindi

31/07/99

21000

M


a)     a)  List the names of female students who are in Hindi Department

b)   b) List the names of all the students with their date of admission in ascending order.

c)   c)  Display student’s name,fee and age for male students only.

d)   d) Count the number of students with age <23.

e)   e) Change the fee of students whose fee is <15000.

Source code and Output:

































Stack Program 2 Write a menu based python program to implement the the operations insert, delete, peek and display on stack.

 Member details: 

MemberNo                     integer

MemberName                String

Age                                integer




def isEmpty(stk):

   if stk==[]:

       return True

   else:

       return False

def push(stk,item):

    stk.append(item)

    top=len(stk)-1

def pop(item):

    if isEmpty(stk):

        return "underflow"

    else:

        item=stk.pop()

        if len(stk)==0:

            top=None

        else:

            top=len(stk)-1

        return item

def peek(stk):

    if isEmpty(stk):

        return "underflow"

    else:

        top=len(stk)-1

        return stk[top]

def Display(stk):

    if isEmpty(stk):

        print("stack empty")

    else:

        top=len(stk)-1

        print(stk[top],"<-top")

        for a in range(top-1,-1,-1):

            print(stk[a])

#main

stk=[]

top=None

while True:

    print("STACK OPERATIONS")

    print("1.push")

    print("2.pop")

    print("3.peek")

    print("4.display")

    ch=int(input("enter your choice(1-4)"))

    if ch==1:

        mno=int(input("enter the member number"))

        mname=input("enter the member name")

        age=int(input("enter the age of member"))

        item=[mno,mname,age]

        push(stk,item)

    elif ch==2:

        item=pop(stk)

        if item=="underflow":

            print("underflow")

        else:

            print("popped item is",item)

    elif ch==3:

        item=peek(stk)

        if item=="underflow":

            print("underflow")

        else:

            print("topmost item is",item)

    elif ch==4 :

        Display(stk)

    else:

       print("invalid")


Output















enter the member number2
enter the member namesathish
enter the age of member35
STACK OPERATIONS
1.push
2.pop
3.peek
4.display
enter your choice(1-4)1
enter the member number3
enter the member namesuresh
enter the age of member36
STACK OPERATIONS
1.push
2.pop
3.peek
4.display
enter your choice(1-4)3
topmost item is [3, 'suresh', 36]
STACK OPERATIONS
1.push
2.pop
3.peek
4.display
enter your choice(1-4)4
[3, 'suresh', 36] <-top
[2, 'sathish', 35]
[1, 'umesh', 34]
STACK OPERATIONS
1.push
2.pop
3.peek
4.display
enter your choice(1-4)2
popped item is [3, 'suresh', 36]
STACK OPERATIONS
1.push
2.pop
3.peek
4.display
enter your choice(1-4)4
[2, 'sathish', 35] <-top
[1, 'umesh', 34]
STACK OPERATIONS
1.push
2.pop
3.peek
4.display
enter your choice(1-4)2
popped item is [2, 'sathish', 35]
STACK OPERATIONS
1.push
2.pop
3.peek
4.display
enter your choice(1-4)4
[1, 'umesh', 34] <-top
STACK OPERATIONS
1.push
2.pop
3.peek
4.display
enter your choice(1-4)2
popped item is [1, 'umesh', 34]
STACK OPERATIONS
1.push
2.pop
3.peek
4.display
enter your choice(1-4)2
underflow
STACK OPERATIONS
1.push
2.pop
3.peek
4.display

Stack based program 3 Write a Python Program to implement a Stack for the book details (bookno,bookname). That is, each item node of the stack contains two types of information- a book number and its name. Implement all the operations of Stack.

 

#source code:

def isEmpty(stk):

    if stk==[]:

        return True

    else:

        return False

def push(stk,item):

    stk.append(item)

    top=len(stk)-1

def pop(stk):

    if isEmpty(stk):

        print("underflow")

    else:

        item=stk.pop()

        if len(stk)==0:

            top=None

        else:

            top=len(stk)-1

        return item

def peek(stk):

    if isEmpty(stk):

        return "underflow"

    else:

        top=len(stk)-1

        return stk[top]

def display(stk):

    if isEmpty(stk):

        print("underflow")

    else:

        top=len(stk)-1

        print(stk[top],"<-top")

        for a in range(top-1,-1,-1):

            print(stk[a])

#main

stk=[]

top=None

while True:

    print("STACK OPERATIONS")

    print("1. Push")

    print("2. pop")

    print("3. peek")

    print("4. display")

    ch=int(input("enter choice"))

    if ch==1:

        bno=int(input("enter bookno to be inserted:"))

        bname=input("enter book name to be inserted:")

        item=[bno,bname]

        push(stk,item)

    elif ch==2:

        item=pop(stk)

        if item=="underflow":

            print("underflow")

        else:

            print("popped item is",item)

    elif ch==3:

        item=peek(stk)

        if item=="underflow":

            print("underflow")

        else:

            print("topmost item is:",item)

    elif ch==4:

        display(stk)

    else:

        print("invalid choice")


Output:





'image.png' failed to upload.

'image.png' failed to upload.