Practical Slip 15 - 2019 Pattern

 Web Technology:

Q1) Write a JavaScript program to Display current Day, Date, Month, Year and Time on the web page and greet the user accordingly.                      [15 M]

Q2) Create HTML page with following specifications                  [25 M]

i) Title should be about your City.

ii) Color the background by Pink color.

iii) Place your city name at the top of page in large text and in blue color.

iv) Add names of the landmarks in your city, each in different color, style and font

v) Add scrolling text about your City.

vi) Add any image at the bottom.

(Use inline CSS to format the web page)

RDBMS:

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

Driver (driver_id, driver_name, address)

Car (license_no, model, year)

Relation between Driver and Car is Many to Many with date and time

as descriptive attribute.

Constraint: Primary key, driver_name 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 the total number of person who are using “Swift” car

2) Write a trigger which will fire before insert or update on year. If year value is more than current year. (Raise user defined exception and give appropriate message)