Practical Slip 1 - 2019 Pattern

 Web Technology:

Q1) Write a JavaScript program to calculate the volume of a sphere.         [15 M]

Q2) Create HTML page to Divide the frames in to different sections as shown below and add appropriate HTML files to each frame.                                    [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 function which will return total maturity amount of policies of a particular client.

2) Write a cursor which will display policy date wise client details.