Practical Slip 22 - 2019 Pattern

 Web Technology:

Q1) Write a java script code to accept a string and write a function to calculate length of string                                                                                           [15 M]

Q2) Create HTML page to Divide the frames in to different sections as shown below and add appropriate HTML files to each frame.                    [25 M]

RDBMS:

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

Country (CId, CName , no_of_states, area, location, population)

Citizen( Id, Name, mother_toung, state_name)

Relation between Country and Citizen is one to many.

Constraint: Primary key, area should not be null.

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

1) Write a procedure to display name of citizens having mother toung “Marathi “ and from “India”;

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