Practical Slip 5 - 2019 Pattern

 Web Technology:

Q1) Write a java script program to accept a number from user and check whether it is perfect number or not.                                                                         [15 M]

Q2) Write HTML code to design a website for Online Shopping. Design home page which consist of list of items each with hyperlink, clicking on which should display related information on separate web page. (Use external CSS to format each web page)                                                                            [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 function which will accept publication name from user and display total price of books of that publication.

2) Write a cursor which will display library wise book details.(Use Parameterized Cursor)