Skip to main content


BCSL-034 Solved Assignment 2017-18 For IGNOU BCA 3rd Semester

Course Code: BCSL-034
Course Title: DBMS LAB
Assignment Number: BCA (3)/L-034/Assignment/17-18
Last Dates for Submission: 15th October, 2017 (For July 2017 Session)
                                               : 15th April, 2018 (For January 2018 Session)
Questions Solved In Assignment:
Que. 1. A Courier Company requires a computerized system to automize its front
office operations that support the following functionalities:
  • Input entries
  • Acceptance of types of Consignments
  • Bill generation
  • Query support
  • Report generation
Update necessary details about the available facilities,
Domestic/International dispatch, charges on various category of delivery
(normal, speed), receipt of incoming consignments, despatch of outgoing
consignments, tracking details of the consignments, registering complaints
Perform the following tasks:
(i) Draw the ER diagram by identifying the entities, relationships and
cardinality by using any of the drawing tools like smartdraw, dia, visio,
conceptdraw etc.. to manage this Courier Company. Follow proper
(ii) Create suitable database to support/accommodate all the functionalities
referred above. Perform Normalization till required NF and prepare
Normalized tables.
(iii) Using MS-Access, design various forms to support the front office
operations such as enquiry, available facilities, types of delivery
(Normal, speed etc..) and charges, pick-up facility, nearest agency,
dispatch, tracking the status of the consignment, delivery of incoming
consignment etc..
(iv) Report generation like daily reports of the costumers visited on day to
day basis, consolidated report on charges collected on a particular day,
dispatch of booked consignments, local receipt and delivery of the
incoming consignments, complaints etc..



Popular This Week

IGNOU BA (BDP) Solved Assignments For All Subjects 2017-18 Session


Download Assignment IGNOU BDP Solved Assignment for 2018 (FREE)BSHF-101 Foundation Course in Humanities and Social SciencesQUESTIONS SOLVED IN ASSIGNMENT:Discuss the different aspects of the non-cooperation movement. Discuss some of the sources of thinking that went in to formulating a strategy for development immediately after independence? What do you understand by the term 'renaissance'? How did the Indian economy adapt to globalisation? Comment. Comment on the main environmental challenges we are facing today?What do you understand by the term 'Fundamental Duties' as given in our constitution? SCQ: Write short notes on any two in about 100 word s each: BharatnatyamSwara in Indian musicDownload Assignment

FST-01 Solved Assignment For IGNOU BDP 2018 Session

IGNOU BDP Solved Assignment for 2018 (FREE)FST-01 Foundation Course In Science and Technology SOLVED ASSIGNMENT IGNOU BA (BDP) Solved Assignment For 2017-18FST-01 Foundation Course In Science and TechnologyQuestions Solved In Assignment:Download For 2017 Download For 2018 IGNOU BDP (BA) SOLVED ASSIGNMENTS FOR ALL COURSES


Download Assignment IGNOU BDP Solved Assignment for 2018 (FREE)FEG-1 BEGF-101 Foundation Course In EnglishQUESTIONS SOLVED IN ASSIGNMENT:Read the following passage and answer the questions that follow: A new study has found that the giant panda’s distinct black - and - white markings have two functions: camouflage and communication. The scientists who earlier uncovered why zebras have black - and - white strips, took the colouration question to giant pandas in the latest study. “Understanding why the giant panda has such striking colouration has been a long - standing problem in biology that has been difficult to tackle because virtually no other mammal has this appearance, making analogies difficult , ” said Tim Caro, a professor at the University of California, Davis in the U.S. “The breakthrough in the study was treating each part of the body as an independent area,” said Mr. Caro. This enabled the team to compare different regions of fur across the giant panda’s body to the dark a…

BEGE-101/EEG-01 Solved Assignment For IGNOU BDP 2017-18

IGNOU BDP Solved Assignment for 2018 (FREE)BEGE-101/EEG-01 Elective Course In English SOLVED ASSIGNMENT Read the following poem carefully and answer the following questions. Amalkanti (Nirendranath Chakrabarti) Amalkanti is a friend of mine, we were together at school. He often came late to class and never knew his lessons. When asked to conjugate a verb, he looked out of the window in such puzzlement that we all felt sorry for him. Some of us wanted to be teachers, some doctors, some lawyers. Amalkanti didn't want to be any of these. He wanted to be sunlight — the timid sunlight of late afternoon, when it stops raining and the crows call again, the sunlight that clings like a s mile to the leaves of the jaam and the jaamrul. Some of us have become teachers, some doctors, some lawyers. Amalkanti couldn't become sunlight. He works in a poorly lit room for a printer. He drops in now and then to see me, chats about this and th at over a cup of tea, then gets up to go. I see him of…