Database managment question

Lab Assignment III (Submission by May 17, 2021)

The solution should be uploaded onto VTOP

Maximum marks 10

Answer ALL questions.

Instructions: Take screen shots of the PL/SQL code as well as execution of the same.

Sharing and/or Copying of answer file or part thereof will be treated as malpractice and the

candidate involved in such practice WILL BE AWARDED ZERO MARKS.

1. Implement and test a PL/SQL block to display train number, train name, passenger name and

age of the passenger and enter the same data into another table with an additional column called

Remarks. The Remarks column should contain information about the type of the train and

whether the passenger is above 60 years of age. (4)

2. Implement and test a PL/SQL block to store day of week and the number of passengers

travelled by trains on the day. The data should be distributed in three different tables based on

which day of the week it is – data for Monday to Wednesday, Thursday and Friday, Saturday and

Sunday should be stored in three different tables. (3)

3. Implement and test a PL/SQL block to display passenger name in the age group of 20 to 30,

his/her boarding station and alighting station when the PNR number of the passenger is entered

interactively. (3)