BCSL-034 Database Management System LabBACHELOR OF COMPUTER APPLICATIONS (BCA)
Term-End Practical Examination
June, 2024 Time : 1 Hour Maximum Marks:50
Note: There are two questions in this paper carrying 20 marks each. Answer them both. Rest 10 marks are for viva-voce.
1. Create the following tables with the fields given below: 20 BUS (ROUTE_NO, START_POINT,DESTINATION, TIME_START, TIME_DEST) PASSENGER (PID,PNAME,GENDER,AGE,MOBILE,ID_PROOF) BOOKING (PID, ROUTE_NO,JRNY_DATE,SEAT_NO) Select appropriate key-constraints for the tables. Input 10 meaningful records. Select appropriate data types for all the fields in three tables. 2. For the above tables created in Q1, answer the following queries using SQL: (20 marks) (a) To display all the passenger names travelling in ROUTE_NO = 112 on 31st Dec., 2023. (4 marks) (b) To display all the ROUTE_NO’s and other details like start-point, destination and timings. (4 marks) (c) To display all passenger details who have AADHAR Card as the ID-Proof for Route-No = 111 on 31st Dec., 2023. (4 marks) (d) To add a column FARE and alter the booking table. (4 marks) (e) To display all the PID, PNAME, AGE of passengers for the JRNY_DATE = 25th Dec., 2023 and ROUTE_NO = 113. (4 marks) The End
Note: There are two questions in this paper carrying 20 marks each. Answer them both. Rest 10 marks are for viva-voce.
1. Create the following tables with the fields given below: 20 BUS (ROUTE_NO, START_POINT,DESTINATION, TIME_START, TIME_DEST) PASSENGER (PID,PNAME,GENDER,AGE,MOBILE,ID_PROOF) BOOKING (PID, ROUTE_NO,JRNY_DATE,SEAT_NO) Select appropriate key-constraints for the tables. Input 10 meaningful records. Select appropriate data types for all the fields in three tables. 2. For the above tables created in Q1, answer the following queries using SQL: (20 marks) (a) To display all the passenger names travelling in ROUTE_NO = 112 on 31st Dec., 2023. (4 marks) (b) To display all the ROUTE_NO’s and other details like start-point, destination and timings. (4 marks) (c) To display all passenger details who have AADHAR Card as the ID-Proof for Route-No = 111 on 31st Dec., 2023. (4 marks) (d) To add a column FARE and alter the booking table. (4 marks) (e) To display all the PID, PNAME, AGE of passengers for the JRNY_DATE = 25th Dec., 2023 and ROUTE_NO = 113. (4 marks)