Practical Slip 29 - 2019 Pattern

 Web Technology:

Q1) Write a JavaScript function that accept three numbers and display the larger number                                                                                                     [15 M]

Q2) Create HTML page with following specifications                               [25 M]

i) Title should be about your City.

ii) Color the background by Pink color.

iii) Place your city name at the top of page in large text and in blue color.

iv) Add names of the landmarks in your city, each in different color, style and font

v) Add scrolling text about your City.

vi) Add any image at the bottom.

(Use Internal CSS to format the web page)

RDBMS:

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

Employee (emp_id, emp_name, address)

Investment (inv_no, inv_name, inv_date, inv_amount)

Relation between Employee and Investment is One to Many.

Constraint: Primary key, inv_amount should be > 0.

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

1) Write a function which will return total investment amount of a particular client.

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