Practical Slip 10 - 2019 Pattern

 Web Technology:

Q1) Write a JavaScript Program to read a number from user, store its factors into the array and display that array. (Handle onClick Event)                            [15 M]

Q2) Write HTML code which generates the following output and display each element of list in different size, color & font. Use inline CSS to format the list.                                                                                                 [25 M]

1. DYP

    • Courses

         BCS

         BCA

2. Indira

    • Courses

         BCA

         MCs

3. ATSS

    • Courses

         BBA

         BCS

RDBMS:

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

Gym (Name, city, charges, scheme)

Member (ID, Name, phoneNo, address)

Relation between Gym and member is one to many.

Constraint: Primary Key, charges must be greater than 0.

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

1) Write a function which will accept member id and scheme from user and display charges paid by that member.

2) Write a trigger which will fire before insert or update on Gym having charges less than 1000. (Raise user defined exception and give appropriate message)