BCSL-034 (Set-4)
BACHELOR OF COMPUTER APPLICATIONS
(BCA)
Database Management Systems Lab
Duration : 1 hour Maximum Marks : 50
Note : 1. There are two questions in this paper carrying 20 marks each. Answer both of them. Rest 10 marks are for viva-voce. 1. Create a table “WORKSHOP” with the following fields: (Name_OF_THE_PARTICIPANT, INSTITUTION, DESIGNATION, CITY, PARTICIPANTION_ID, FEE_PAID(YES/NO) AMOUNT, ACCOMMODATION_REQUIRED (YES/NO), MOB-NO, EMAIL, ADDRESS,CITY,STATE) Select appropriate data types for each of the fields. Identify the primary key. Input meaningful data for at least 10 records. (20) 2. For the above table created in Q.1 Answer the following queries using SQL: (4x5=20) (a) To display all the participants with designations “Assistant Professor”. (b) To display all the participants who are form “Arunachal Pradesh” (c) To display total-amount paid by all the participants (d) To display all the participants who requires accommodation