Practical Slip 23 - 2019 Pattern

 Web Technology:

Q1) Write a java script code to accept a number and write a function to calculate sum of digits of that number                                                                         [15 M]

Q2) Write HTML code to create following table. (use External CSS to format the table)                                                                                                            [25 M]

RDBMS:

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

Wholesaler (w_no, w_name, address, city)

Product (product_no, product_name, rate)

Relation between Wholesaler and Product is Many to

Many with quantity as descriptive attribute.

Constraint: Primary key, rate should be > 0.

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

1) Write a procedure which will display details of products supplied by “Mr. Patil”

2) Write a cursor which will display wholesaler wise product details.(Use Parameterized cursor)