Practical Slip 4 - 2019 Pattern

 Web Technology:

Q1) Write a java script program to accept a number from user and check whether it is Armstrong number or not                                                                       [15 M]

Q2) Create HTML web page with following specifications                        

i) Title should be about your College.

ii) Put image in the background

iii) Place your college name at the top of page in large text followed by address in

smaller size.

iv) Add names of courses offered, each in different color, style and font

v) Add scrolling text about college.

vi) Add any image at the bottom.

(use External CSS to format the webpage)                                                                                                                        [25 M]

RDBMS:

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

Client (client_no, client_name, address, birthdate)

Policy_info (policy_no, desc, maturity_amt, prem_amt, date)

Relation between Client and Policy_info is Many to Many

Constraint: Primary key, prem_amt and maturity_amt should be > 0.

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

1) Write a procedure which will display all policy details having premium amount less than 5000.

2) Write a trigger which will fire before insert or update on policy_info having maturity amount less than premium amount. (Raise user defined exception and give appropriate message)