Practical Slip 25 - 2019 Pattern

 Web Technology:

Q1) Write a JavaScript function that reverse a input number                       [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]

Gym (Name, city, charges, scheme)

Member (ID, Name, phoneNo, address)

Relation between Gym and member is one to many.

Constraint: Primary Key, charges must be greater than 0.

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

1) Write a procedure to display member details of gym located at “Pimpri’”

2) Write a cursor which will display gym wise member details.(Use Parametrized Cursor)