Practical Slip 14 - 2019 Pattern

 Web Technology:

Q1) Write a HTML code to display the name of your family members each in different color, size and style. Also display the following polynomial expression         a0+a1x^1+a2x^2+a3x^3+a4x^4                                                             [15 M]

Q2) Write a JavaScript Program to accept user name and password from user, if User name and Password is same then display his score card on the next page as shown below.                                                    [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 procedure which will accept teacher name from user and display his/her college details.

2) Write a trigger which will fire before insert or update on Teacher having salary less than or equal to zero (Raise user defined exception and give appropriate message)