Practical Slip 12 - 2019 Pattern

 Web Technology:

Q1) Design a student registration form with fields Name, Address, city and Pin-Code. Write a java script program to perform following validation:

i. Check name should not be empty and contain alphabets only

ii. Pin-code must be 6 digits only                                                               [15 M]

Q2) Create HTML page with following specifications 

i) Title should be about your College.

ii) Put image in the background

iii) Place your college name at the top of page in large text followed by address

 in smaller size.

iv) Add names of courses offered, each in different color, style and font

v) Add scrolling text about college.

vi) Add any image at the bottom.

(Use Internal CSS to format the web page)                           [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 function which will accept wholesaler name from user and will display total number of items supplied by him.

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