Practical Slip 13 - 2019 Pattern

 Web Technology:

Q1) Design a login form with fields User Name, Password and Login button. Write a java script code to accept username and password, validate login details and display a message accordingly.                                                                 [15 M]

Q2) Write a HTML code which will divide web page in three frames. First frame should consists of name of college as heading. Second frame should consists of name of courses with hyperlink. Once click on any course it should display subject of that course in third frame.                                        [25 M]

RDBMS:

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

Country (CId, CName , no_of_states, area, location, population)

Citizen( Id, Name, mother_toung, state_name)

Relation between Country and Citizen is one to many.

Constraint: Primary key, area 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 display name of the country having minimum population.

2) Write a cursor which will display county wise citizen details.