Practical Slip 28 - 2019 Pattern

 Web Technology:

Q1) Write a JavaScript program to construct the following pattern up to n lines, using a nested for loop.                                                                             [15 M]

*

* *

* * *

Q2) Design a HTML form for Bus Ticket Reservation consisting of fields for Name, Address, contact no, source station(Dropdown list), Destination station, Date of booking, date of journey, no of passenger, name of passenger, gender of passenger etc. You should provide button to submit as well as reset the form contents. (Use proper alignment).                                                            [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 function which accept a table number and display total amount of bill for a specific table

2) Write a cursor which will display table wise menu details.