Practical Slip 27 - 2019 Pattern

 Web Technology:

Q1) Write a JavaScript function to compute the sum of factors of a input number                                                                                                                         [15 M]

Q2) Write a HTML code to display calendar of current month in tabular format. Use proper color for week days and holidays. Display month name, year and images as advertisement at the beginning of the calendar.                                        [25 M]

RDBMS:

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

Plan (plan_no, plan_name, nooffreecalls, freecalltime, fix_amt)

Customer (cust_no, cust_name, mobile_no)

Relation between Plan and Customer is One to Many.

Constraint: Primary key, fix_amt should be greater than 0.

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

1) Write a procedure to display the plan having minimum response.

2) Write a trigger which will fire before insert or update on mobile number having length less than or greater than10. (Raise user defined exception and give appropriate message)