Practical Slip 6 - 2019 Pattern

 Web Technology:

Q1) Write java script program to accept a number from user and check whether it is prime number or not                                                                            [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]

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 procedure which will display details of employees invested amount in “Mutual Fund”

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