Practical Slip 2 - 2019 Pattern

 Web Technology:

Q1) Write a java script program to accept a number form user and display its multiplication table                                                                                     [15 M]

Q2) Write the HTML code to create the following table. Use internal CSS to format the table                                                                                                  [25 M]

RDBMS:

Q3) Consider the following Item_Supplier database                                [40 M]

Item (itemno, itemname )

Supplier (supplier_No , supplier_name, address, city )

Relationship between Item and Supplier is many-to-many with descriptive attribute

rate and quantity

Constraints: itemno ,supplier_No primary key

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

1) Write function to print the total number of suppliers of a particular item

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