Practical Slip 21 - 2019 Pattern

 Web Technology:

Q1) Write a java script code to accept the values of x and y and then display xy                                                                                                                       [15 M]

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

o Coffee

o Tea

•      Black Tea 
•      Green Tea

        1) Africa

        2) China                                      [25 M]

RDBMS:

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

College (code, college_name, address)

Teacher (teacher_id, teacher_name, Qualification, specialization, salary, Desg)

Relation between Teacher and College is Many to One.

Constraint: Primary Key, qualification 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 college name from user and display total number of “Ph.D” qualified teachers.

2) Write a cursor which will display college wise teacher details.