Practical Slip 19 - 2019 Pattern

 Web Technology:

Q1) Write a java script code to accept a number form user and display its factorial.                                                                                                      [15 M]

Q2) Design an HTML form to take the information of a customer for booking a travel plan consisting of fields such as name, address, contact no., gender, preferred season(Checkboxes), location type(to be selected from a list) etc. You should provide button to submit as well as reset the form contents. (All the fields should be properly aligned)                                                  [25 M]

RDBMS:

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

Game (game_name, no_of_players, coach_name)

Player (pid, pname, address, club_name)

Relation between Game and Player is Many to Many.

Constraint: Primary key, no_of_players should be > 0.

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

1) Write a function which will return total number of football players of “Sports Club”.

2) Write a cursor which will display club wise details of players.