Practical Slip 3 - 2019 Pattern

 Web Technology:

Q1) Write a java script program to accept a number form user and calculate and display its sum of digits.                                                                            [15 M]

Q2) Write HTML code to design a web as per given specification. Divide the browser screen into two frames. The first frame will display the heading. Divide the second frame into two columns. The frame on the left should be name of cities consisting of hyperlinks. Clicking on any one of these hyperlinks will display related information in right hand side frame as shown below.                                                                                                                        [25 M]

RDBMS:

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

Newspaper (name,language , publisher , cost )

Cities (pincode , city, state)

Relationship between Newspaper and Cities is many-to-many with descriptive

attribute daily required

Constraints: name and pincode primary key

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

1) Write a trigger which will fire before insert on the cities table which check that the

pincode must be of 6 digit. (Raise user defined exception and give appropriate message).

2) Write a procedure to calculate city wise total cost of each newspaper.