Question

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 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 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 list of participants (event-wise), list of resource persons (event-wise) etc..

Answer 1

Answer:

kbkzwvvkwwvkzkwvvziiwvvsi2xs

Answer 2

Answer:

An ABC Event Management Company requires a computerized system to automize its operations that support the following activities

Explanation:

From the above question,

They have given :

(i) ER Diagram: To create the ER diagram, identify the entities (e.g. Event, Participant, Resource Person, etc.), the relationships between the entities (e.g. one event has many participants, one event has many resource persons, etc.), the cardinality (e.g. one-to-many, many-to-many, etc.), and the key constraints (e.g. primary keys, foreign keys, etc.). Proper conventions, such as using standard symbols and notations, should be followed.

(ii) Normalized Tables: To create the normalized tables, perform normalization on the entities identified in the ER diagram till required NF. Ensure that the tables are in the third normal form (3NF) or higher, to minimize data redundancy and improve data consistency.

(iii) MS-Access Implementation: To implement the system using MS-Access, design various forms to support the event marketing and event registration modules. The forms should be user-friendly and allow data input, retrieval, and modification.

(iv) Report Generation: To generate reports, create expenditure statements for event-marketing (event-wise), lists of participants (event-wise), and lists of resource persons (event-wise). Ensure that the reports are easy to read and understand, and include all the necessary information.

For more such related questions : https://brainly.in/question/36075661

#SPJ3