Practical Slip 18 - 2019 Pattern

 Web Technology:

Q1) Write a java script program to accept the value of n and display all odd numbers up to n.                                                                                      [15 M]

Q2) Write the HTML code which generates the following output. (Use external CSS to format the given table)                                         [25 M]

RDBMS:

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

Student (s_reg_no, s_name, s_class)

Competition (comp_no, comp_name, comp_type)

Relationship between Student and Competition is many-to-many with descriptive

attribute rank and year.

Constraints: primary key, foreign key, primary key for third table(s_reg_no, comp_no, year),s_name and comp_name should not be null,comp_type can be sports or academic.

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

1) Write a function which will accept s_reg_no of student and returns total number of competition in which student has participated in a given year.

2) Write a cursor which will display year wise details of competitions.

(Use parameterized cursor)