BCSL-034 DBMS Lab Solved Assignment 2020-2021

Download Now

Course Code : BCSL-034
Course Title : DBMS Lab
Assignment Number : BCA(3)/034/Assignment/2020-21
Maximum Marks : 50
Weightage : 25%
Last Date of Submission : 31st October, 2020 (For July, 2020 Session)
: 15th April, 2021 (For January, 2021 Session)

Title Name

BCSL-034 DBMS Lab Solved Assignment 2020

University IGNOU
Service Type Solved Assignment (Soft copy/PDF)
Course BCA
Language ENGLISH
Semester 2020 Course: BCA
Session 2020-2021
Short Name BCSL-034 DBMS Lab
Assignment Code  BCA(3)/034/Assignment/2020-21
Product Assignment of BCSL-034 (IGNOU)
Submission Date 31st October, 2020 (For July, 2020 Session)

15th April, 2021 (For January, 2021 Session)



Download Now

This assignment has only one question. Answer the question. This question carries 40
marks. Rest 10 marks are for viva voce. You may use illustrations and diagrams to
enhance the explanation. Please go through the guidelines regarding the assignments
given in the programme guide for the format of presentation
Q1. A Hostel Management System for a University requires a computerized system to
automize its operations that support the following activities:
Registration for UG/PG students
Hostel Rooms Allocation
Hostel Warden
Hostel Mess
Basic amenities in the room
Hostel community room maintenance
Maintenance/complaints handling (lights, fans, taps, electricity, stair-case lighting etc.,)
Query support
Report generation
Perform the following tasks:
(i) Using any of the drawing tools like smartdraw, dia, visio, conceptdraw etc. or
else by your own hand, draw the complete ER diagram for the above event
management system by identifying the entities, relationships, cardinality and key
constraints. Follow proper conventions.
(ii) Create database to support/accommodate all the functionalities referred above.
Perform Normalization till required NF and prepare Normalized tables.
(iii) Using MS-Access, implement by designing various forms to support the above
(iv) Report generation should include the expenditure statement for list of students
along with room-nos., reports of expenditure in hostel-mess, expenditure incurred
in hostel maintenance etc..
Note: You must perform the above said activities and also take prints of
screenshots of the layouts, sample input and output along with the necessary
documentation for this practical question. Assumptions can be made wherever

Download Now

BCSL-034, BCSL 034, BCSL034, BCSL-34, BCSL34, BCSL 34


Please enter your comment!
Please enter your name here