Practical Slip 7 - 2019 Pattern

 Web Technology:

Q1) Write a java script program to accept a string from user and display the count of vowel characters from that string.                                                       [15 M]

Q2) Write a HTML code to display Theory Time Table of FYBBA(CA). Use internal CSS to format the table                                                             [25 M]

RDBMS:

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

Bill (billno, day, tableno, total)

Menu (dish_no, dish_desc, price)

The relationship between Bill and Menu is Many to Many with quantity as descriptive attribute.

Constraint: Primary key, price should be > 0.

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

1) Write a procedure to display menu details having price between 200 to 500 which were order on ‘Saturday’ .

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