BCSL-034 ASSIGNMENT SOLUTION (2020-21)- ignou solved assignments 2021

 

Dear students, get fully  solved assignments by professionals

Do send your query at :

help.mbaassignments@gmail.com

 

or call us at :08263069601

 

 

BCSL-034 ASSIGNMENT SOLUTION (2020-21)

 

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 :

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.

Create database to support/accommodate all the functionalities referred above. Perform Normalization till required NF and prepare Normalized tables.

Using MS-Access, implement by designing various forms to support the above modules

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..

Answer : - 

 

Dear students, get fully  solved assignments by professionals

Do send your query at :

help.mbaassignments@gmail.com

 

or call us at :08263069601

 

 

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.