Practical Slip 11 - 2019 Pattern

 Web Technology:

Q1) Write a JavaScript program to accept a string and a position (number) from user and display the character at specified position.                                  [15 M]

Q2) Write HTML code which generates the following output and display each element of list in different size, color & font. Use external CSS to format the list                                                                   [25 M]

• Non flowering plants

    o Fern

    o Spore

• Flowering plants

•      Lilly
•      Rose

            1. Red Rose

            2. Pink Rose

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 function which will accept Lab number from user and display total number of student allocated in that lab.

2) Write a cursor which will display lab wise student details.