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

This assignment has only one question. Answer the question. This question carries 40 marks. The 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 program guide for the format of presentation

Q1. An ABC Event Management Company requires a computerized system to automize its

operations that support the following activities:
 Event Marketing (like Marketing channels include social media, email marketing, media, and blog sites)
 Event Registration(Online and Offline at the venue)
 Badges printing for all the participants
 Scheduling of Events
 Complete Budget Management for the Event
 Event Reporting
 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 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 a database to support/accommodate all the functionalities referred to above. Perform Normalization till required NF and prepare Normalized tables.

(iii) Using MS-Access, implement by designing various forms to support two modules

(i) event marketing and

(ii) event registration activities mentioned above.

(iv) Report generation should include the expenditure statement for event-marketing (event-wise), reports of the list of participants (event-wise), list of resource persons (event-wise), 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 necessary

About Abhishek Pandey

My name is Abhishek Pandey, I am fond of writing the best content and apart from writing I am an SEO specialist as well. I have written many blogs and post so far that have ranked on the first page. I am a video editor as well and I have got three-channel on youtube. In nutshell, I am the allrounder of digital marketing and I want to flourish more and more.

Leave a Reply

Your email address will not be published. Required fields are marked *