Practical Slip 30 - 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]

A

B C

D E F

Q2) Write a HTML code to create the following table. Use External CSS to format the table.                                                                                                     [25 M]

RDBMS:

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

Library(Lno, Lname, Location, Librarian, no_of_books)

Book(Bid, Bname, Author_Name, Price, publication)

Relation between Library and Book is one to many.

Constraint: Primary key, Price should not be null.

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

1) Write a procedure to display names of book written by “Mr. Patil” and are from “DPU Library”.

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