Practical Slip 17 - 2019 Pattern

 Web Technology:

Q1) Write a java script code to accept a string from user and display the occurrences of every vowel character from string                                    [15 M]

Q2) Design an HTML form for customer registration visiting a departmental store. Form should consists of fields such as name, contact no, gender, preferred days of purchasing, favorite item(to be selected from a list of items),suggestions etc.. You should provide button to submit as well as reset the form contents.                                                                           [25 M]

RDBMS:

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

Company (name , address , city , phone , share_value)

Person (pname ,pcity )

Relationship between Company and Person is M to M relationship with descriptive

attribute No_of_shares i

Constraints: name,pname primary key

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

1) Write a trigger before insert or update on No_of_shares field should not be

zero.(Raise user defined exception and give appropriate message)

2) Write a function to display total no_of_shares of a specific person.