IGNOU BCA BCSL-034 Study Materials /Notes/ Impotent Questions | ignou bca study materials

IGNOU BCA BCSL-034 Exam Most Questions  Free For 2022-23 Session: If you were searching for the IGNOU BCA BCSL-034 Exam Most Questions  free for 2022-23 Session then finally you are at right place as IGNOU BCA BCSL-034 Exam Most Questions for free 2022-23 is now available IGNOU BCA BCSL-034 Exam Most Questions   PDF files from here.

IGNOU BCA BCSL-034 Exam Most Questions  Free For 2022-23 Session

Students may easily bca bcsl-034 know about their Assignment Topics by clicking on the official link of IGNOU. All-important links  bca bcsl-034 will be shared on the web Panel. 

BCSL-034(P)/S1 : DATABASE MANAGEMENT SYSTEMS LAB

IGNOU BCA BCSL-034 Exam Most Questions

(1.) For the above table in Q.1, answer the following queries using SQL

(a) To display all the records, sorted in ascending order with respect to distance.

(b) To display the ROUTE_ID and ROUTE_NO whose FARE > 400.

(c) To display in the SEATING_CAPACITY for any particular ROUTE_ID.

(d) Display the average total fare.

(e) Display above all the types of CATEGORY_CODEs.

(2.)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.

(3.)For the above database created in Q.1, answer the following queries using

SQL :

(a) To find the EName and ENo of all the employees who work for PNo = 111.

(b) To display the no. of hours allocated for ENo = 001.

(c) To display all the projects whose PLocation is "Delhi".

(d) To display all the DNos and DLocations.

(e) To display all the ENos and ENames of the company.

(4.)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, EMAIL, CONTACT_ADDR1,

CONTACT_ADDR2, STATE)

Select appropriate datatypes for each of the fields. Identify the primary key. Input meaningful data of at the least 10 records. 20

(5.) For the above table created in Q.1, answer the following queries using SQL

(a) To display in the total number of participants from MUMBAI city.

(b) To display all the PAPER_ID of the presenters in the conference.

(c) To display in the total amount received from all the participants/presenters.

(d) To display the list of all the participants with designation Associate Professor.

(6.)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.

(7.). For the above table all the 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 availing LTC.

(c) To display all the list of employees with the Destination_City BANGALORE.

(d) To display all the employees who are there travelling only "SELF"..
v

How to Download IGNOU Solved Assignment?

 1.       Send your subject code / Enter Your assignment code in whats app .

2.      Click on Assignments codes types /screen shoot .

3.      Enter your right Subjects code.

4.      Click on “sent ”.

5.       select (all payments methods available)

6.      Success your transaction than check your Whats app  Automatically download

7.      Download the Assignment.

IGNOU more assignments B.A/BDP/BAG/BCA/MCA/PGDCA/MBA  ALSO AVILABLE

BELOW

IGNOU PROGRAMMES	SELECT
IGNOU All Solved  Assignments	Click here
IGNOU BCA Solved Assignments	Click here
IGNOU MCA Solved Assignments	Click here
IGNOU BAG/BDP/BA Solved Assignments	Click here
IGNOU PGDCA Solved Assignments	Click here
IGNOU MBA Solved Assignments	Click here
IGNOU Other Assignments	Click here

IGNOU MCA/MCA New Handwriting pdf Available 2022-23 

IGNOU SOLVED ASSIGNMENTS 2022-23 

BAG	MCA	BCA
PGDCA	MBA	BA/BDP
B.COM	M.COM	M.A

All-important links will be shared ignou all on the web Panel. This is the Distance education ignou University and that is why students are needed to make their Assignments at their Home. If you are feeling any doubt, then ask from us by below large comment box here..