Practical Slip 24 - 2019 Pattern

 Web Technology:

Q1) Write a java script code to accept a number and write a function to calculate sum of digits of that number                                                                         [15 M]

Q2) Write html code to display following list. (use internal CSS to format the list)                                                                                                                        [25 M]

i. Arts 

    • BA

    • MA

ii. Commerce

    • Bcom

    • Mcom

iii. Science

    • B.Sc.

    • M.Sc.

RDBMS:

Q3) Consider the following entities and their relationships.                       [40 M]

Student (rollno, sname, class, timetable)

Lab (LabNo, LabName, capacity, equipment)

Relation between Student and Lab is Many to One.

Constraint: Primary Key, capacity should not be null.

Create a RDB in 3NF and write PL/SQL blocks in Oracle for the following:

1) Write a procedure to display details of students which perform practical sessions in a given Lab.

2) Write a trigger which will fire before delete on Lab (Raise user defined exception and give appropriate message)