Practical Slip 26 - 2019 Pattern

 Web Technology:

Q1) Write a JavaScript function that checks whether a input string is palindrome or not.                                                                                                              [15 M]

Q2) Write HTML and CSS code to design a web page. Divide the browser screen into two frames. The first frame will display the heading. The second frame contains a menu consisting of hyperlinks. Clicking on any one of these hyperlinks will display related information in a new page                                                               [25 M]

RDBMS:

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

Project (pno, pname, start_date, budget, status)

Department (dno, dname, HOD, loc)

The relationship between Project and Department is Many to One.

Constraint: Primary key.

Project Status Constraints: C – Completed,

P - Progressive,

I – Incomplete

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

1) Write a procedure to display the name of HOD who has completed maximum project.

2) Write a trigger which will fire before insert or update on project having budget less than or equal to zero. (Raise user defined exception and give appropriate message)