IGNOU BCA/MCA all semester new revised (1st semester,2nd semester,3rd semester,4th semester,5th semester and 6th semester) term-end exam notes,study materials,important questions,books/blocks,previous years paper,upcoming guess paper (June-December) free download.
SET-1
1. Create the following table "WORKSHOP" with the following fields :
(NAME_OF_THE_PARTICIPANT, INSTITUTION, DESIGNATION, CITY,PARTICIPANT_ID, FEES_PAID (YE S/NO), AMOUNT,ACCOMMODATION_REQUIRED (YES/NO), MOB_NO, EMAIL,CONTACT_ADDR1, CONTACT_ADDR2, STATE)
Select appropriate datatypes for each of the fields. Identify the primary key.Input meaningful data of at least 10 records.
2. For the above table created in Q.1, answer the following queries using SQL :
(a) To display all the participants with designations Assistant Professors and who are from Delhi.
(b) To display only the list of names of all the participants who require accommodation also.
(c) To display the total amount paid by all the participants.
(d) List all the Mob_no, Email addresses along with the names of the participants.
SET-2
1. Create the following table "NATIONAL_CONFERENCE" with the following fields
(NAME_OF_THE_PARTICIPANT, ORGANISATION/UNIVERSITY,PAPER_ID, DESIGNATION, PARTICIPANT_ID, CITY, AMOUNT_PAID,ACCOMMODATION_REQUIRED (YES/NO),
PARTICIPANT/PAPER_PRESENTER, MOB_NO, MAIL,CONTACT_ADDR1,CONTACT_ADDR2, STATE)
Select appropriate datatypes for each of the fields. Identify the primary key.Input meaningful data of at least 10 records.
2. For the above table created in Q.1, answer the following queries using SQL :
(a) To display the total number of participants from MUMBAI city.
(b) To display all the PAPER_ID of the presenters in the conference.
(c) To display the total amount received from all the participants/presenters.
(d) To display the list of all the participants with designation Associate Professor.
SET-3
1. Create the following table "LEAVE_TRAVEL_CONCESSION" with the following fields :
(NAME_OF_THE_EMPLOYEE, EMP_ID, DESIGNATION, BASIC_PAY+AGP,
BLOCK YEAR (2014 — 2017/2011 — 2013),WHETHER_AVAIL_LEAVE_ENCASHMENT (YES/NO),ANY_WHERE/HOME_TOWN, TRAVEL_START_DATE, TRAVEL_END_DATE,
SELF/FAMILY, DESTINATION_CITY, AIR/RAILWAY/BUS)
Select appropriate datatypes for each of the fields. Identify the primary key.Input meaningful data of at least 10 records.
2. For the above table created in Q.1, answer the following queries using SQL :
(a) To display all the employees availing the LTC of current slot (2014 — 2017).
(b) To display the list of all the employees with designation DIRECTOR availingLTC.
(c) To display all the list of employees with the Destination_City BANGALORE.
(d) To display all the employees who are travelling only "SELF".
SET-4
1. Create the following table "STUDENT_ASSIGNMENTS_SUBMISSION" with the following fields :
(NAME_OF_THE_STUDENT, ENROL_NO, PROGRAMME,PROGRAMME_CODE, RC, RC_CODE, SC_CODE, CITY, SEMESTER,A_COURSE1, A_COURSE2, A_COURSE3, A_COURSE4, A_COURSE5,A_LAB_COURSE1, A_LAB_COURSE2, DATE_OF_SUBMISSION)
Select appropriate datatypes for each of the fields. Identify the primary key.Input meaningful data of at least 10 records.
2. For the above table created in Q.1, answer the following queries using SQL :
(a) To display all the students with name and enrol no. who belong to BCA 3rdsemester.
(b) To display all the student details who submitted the A_Course1 assignments within the due date.
(c) To display all the BCA students who reside in DELHI State.
(d) List the Enrol_no of all who have submitted the assignments during Sept-2015.
IGNOU BCA BCSL-034 Term-End Practical Examination (DATABASE MANAGEMENT SYSTEMS LAB) term-end exam notes Download
IGNOU BCA BCSL-034 Term-End Practical Examination (DATABASE MANAGEMENT SYSTEMS LAB) books/block,term-end exam notes,upcoming guess paper,important questions,study materials,previous year papers download.
1. Create the following table "WORKSHOP" with the following fields :
(NAME_OF_THE_PARTICIPANT, INSTITUTION, DESIGNATION, CITY,PARTICIPANT_ID, FEES_PAID (YE S/NO), AMOUNT,ACCOMMODATION_REQUIRED (YES/NO), MOB_NO, EMAIL,CONTACT_ADDR1, CONTACT_ADDR2, STATE)
Select appropriate datatypes for each of the fields. Identify the primary key.Input meaningful data of at least 10 records.
2. For the above table created in Q.1, answer the following queries using SQL :
(a) To display all the participants with designations Assistant Professors and who are from Delhi.
(b) To display only the list of names of all the participants who require accommodation also.
(c) To display the total amount paid by all the participants.
(d) List all the Mob_no, Email addresses along with the names of the participants.
SET-2
1. Create the following table "NATIONAL_CONFERENCE" with the following fields
(NAME_OF_THE_PARTICIPANT, ORGANISATION/UNIVERSITY,PAPER_ID, DESIGNATION, PARTICIPANT_ID, CITY, AMOUNT_PAID,ACCOMMODATION_REQUIRED (YES/NO),
PARTICIPANT/PAPER_PRESENTER, MOB_NO, MAIL,CONTACT_ADDR1,CONTACT_ADDR2, STATE)
Select appropriate datatypes for each of the fields. Identify the primary key.Input meaningful data of at least 10 records.
2. For the above table created in Q.1, answer the following queries using SQL :
(a) To display the total number of participants from MUMBAI city.
(b) To display all the PAPER_ID of the presenters in the conference.
(c) To display the total amount received from all the participants/presenters.
(d) To display the list of all the participants with designation Associate Professor.
SET-3
1. Create the following table "LEAVE_TRAVEL_CONCESSION" with the following fields :
(NAME_OF_THE_EMPLOYEE, EMP_ID, DESIGNATION, BASIC_PAY+AGP,
BLOCK YEAR (2014 — 2017/2011 — 2013),WHETHER_AVAIL_LEAVE_ENCASHMENT (YES/NO),ANY_WHERE/HOME_TOWN, TRAVEL_START_DATE, TRAVEL_END_DATE,
SELF/FAMILY, DESTINATION_CITY, AIR/RAILWAY/BUS)
Select appropriate datatypes for each of the fields. Identify the primary key.Input meaningful data of at least 10 records.
2. For the above table created in Q.1, answer the following queries using SQL :
(a) To display all the employees availing the LTC of current slot (2014 — 2017).
(b) To display the list of all the employees with designation DIRECTOR availingLTC.
(c) To display all the list of employees with the Destination_City BANGALORE.
(d) To display all the employees who are travelling only "SELF".
SET-4
1. Create the following table "STUDENT_ASSIGNMENTS_SUBMISSION" with the following fields :
(NAME_OF_THE_STUDENT, ENROL_NO, PROGRAMME,PROGRAMME_CODE, RC, RC_CODE, SC_CODE, CITY, SEMESTER,A_COURSE1, A_COURSE2, A_COURSE3, A_COURSE4, A_COURSE5,A_LAB_COURSE1, A_LAB_COURSE2, DATE_OF_SUBMISSION)
Select appropriate datatypes for each of the fields. Identify the primary key.Input meaningful data of at least 10 records.
2. For the above table created in Q.1, answer the following queries using SQL :
(a) To display all the students with name and enrol no. who belong to BCA 3rdsemester.
(b) To display all the student details who submitted the A_Course1 assignments within the due date.
(c) To display all the BCA students who reside in DELHI State.
(d) List the Enrol_no of all who have submitted the assignments during Sept-2015.
IGNOU BCA BCSL-034 Term-End Practical Examination (DATABASE MANAGEMENT SYSTEMS LAB) term-end exam notes Download