Practical Slip 9 - 2019 Pattern

 Web Technology:

Q1) Write a java script program to accept a string and check whether the input string is palindrome string or not.                                                               [15 M]

Q2) Write the HTML code which generates the following output.(use internal CSS to format the table                                                                                                                                                                        [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 function which accept department name and display total number of projects whose status is “p”(progressive).

2) Write a cursor which will display status wise project details of each department.