 |
| BCSL-034 Solved Assignment 2017-18 For IGNOU BCA 3rd Semester |
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
etc..
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
conventions.
(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..
