Practical-206 paper solution

Q-1 [A] Write a Python program to print Fibonacci series up to n terms. 

N=int(input('Enter a N : ')) 

A=0

B=1

for i in range(0, N) :

        Print(A, end=' ') 

        C=A+B

        A=B

        B=C

Q-1 [B] Write a program that creates structure of student with student id, name, percentage. Enter data of five students. Display data of those student whose percentage is less than 70 marks. 

#include <stdio.h>

#include <conio.h>

struct Student

{

    int id, percentage;

    char name[50];

};

void main()

{

    struct Student stu[5];

    clrscr();

    for (int i = 0; i < 5; i++)

    {

        printf("\nEnter data for student %d:\n", i + 1);

        printf("Enter student ID: ");

        scanf("%d", &stu[i].id);

        printf("Enter student name: ");

        scanf("%s", stu[i].name);

        printf("Enter student percentage: ");

        scanf("%d", &stu[i].percentage);

    }

    printf("\nStudents with percentage less than 70%:\n");

    printf("\nId\tName\tPercentage\n\n");

    for (int i = 0; i < 5; i++)

    {

        if (stu[i].percentage < 70)

        {

            printf("%d\t%s\t%d\n", stu[i].id, stu[i].name, stu[i].percentage);

        }

    }

    getch();

}

Q-2 [A] Create following tables and apply appropriate constraints Insert at least 10 records in each table.

Distributor(dno, name, phoneno)

Item(ino, Name, color) 

Dist_item(dno, ino, qty)

Create table Distributor

(dno number primary key, 

name varchar(20), 

Phoneno number) ;

Create table Item

(ino number primary key, 

name varchar(20), 

color varchar(20)) ;

Create table Dist_item

(dno number, 

Constraint a foreign key(dno) references Distributor(dno), 

ino number, 

Constraint b foreign key(ino) references Item(ino), 

Qty number) ;

Q-2 [B] Write a PL/SQL block to takes input of the department no and display the information of particular distributor. 

DECLARE

        v_dno number:=&dno;

        v_name varchar(20) ;

        v_phoneno number;

BEGIN

        SELECT name, phoneno INTO v_name, v_phoneno FROM Distributor WHERE dno = v_dno;

        DBMS_OUTPUT.PUT_LINE('Distributor Id: ' || v_dno);

        DBMS_OUTPUT.PUT_LINE('Distributor Name: ' || v_name);

        DBMS_OUTPUT.PUT_LINE('Phone Number: ' || v_phoneno);

END;

/