project blog responsive ads

Free download management system project documentation with JAVA, PHP AND ASP.NET source code. In all project report you will get introduction and objective of the project, system analysis, feasibility study, project planning, DFD diagram, system design, database design, complete project coding, and ER diagram of the project. These project reports and synopsis are useful for BCA, MCA BSC CS, MSC IT B.TECH, M.TECH and BE computer science last year students IGNOU, SMU university final year projects

Sponsored Links

Friday, September 27, 2013

Free BCA Project Event management system DFD and ER Diagram and Complete Database and tables


DFD (Data flow diagram) of Free BCA Project event management systme


Free BCA PROJECT # 1 ONLINE EXAMINATION  SYSTEM 

FREE BCA PROJECT # 2- HOSPITAL INFORMATION SYSTEM

FRONT END - VB6.0BACK END - SQL SEVER 2000



Free BCA Project 3#  ONLINE AUCTION SYSTEM


   FRONTEND - C # AND .NET FRAMEWORK 

   BACKEND - SQL SERVER 2008


   Download Project SYNOPSIS OF  ONLINE AUCTION SYSTEM

   Free download FINAL REPORT OF PROJECT  ONLINE AUCTION SYSTEM



FREE BCA PROJECT # 4MEDICAL & SURGICAL SUPPLIERS

FREE DOWNLOAD PROJECT SYNOPSIS OF   MEDICAL & SURGICAL SUPPLIERS

FREE DOWNLOAD PROJECT FINAL REPORT OF   MEDICAL & SURGICAL SUPPLIERS

Free BCA Project 1

DFD (Data flow diagram) of Free BCA Project event management systme
            A  DFD is a graphical representation that depicts information flow and  the transforms that are applied as data move from input to output. The  DFD may be used to represent a system or software at any level of abstraction DFD’s may be partitioned into levels that represent increasing information flow and functional details. The DFD provides a mechanism for functional modeling as well as information flow modeling.
A level “O” DFD, also called a fundamental system model or a context model , represents the entire software  element as single bubble with input and output data indicated by incoming and outgoing arrows respectively.
A level “1” DFD contain five or six bubbles with interconnecting arrows. Each of the processes represented at level 1 is a sub function  of the overall system.
Similarly DFD level 1 can be refined into next level 2 .The information flow continuity has been maintained between each levels.

DFD ‘0’Level

Free BCA Projects Event management system DFD 0 and DFD 1
DFD '2' Level
Free BCA Project Event management project 2 Level DFD

Entity Relationship Diagram ER Diagram

Class Diagram
Free BCA project event management Class diagram

8. A Complete Database and tables detail with Primary and Foreign Keys, and proper Constraints in Free BCA Project fields..

Database Design and RDBMS
The general theme behind database design is to handle information as on integrated whole. There is none of the artificiality that is normally embedded in separate files or applications. A database is a collection of interrelated data stored with minimum redundancy to serve many users quickly and efficiently. The general objective is to make information access easy, quick, inexpensive and flexible for the user. In database design of this project several objectives were considered.
1.           Controlled redundancy: Redundant data occupies space and therefore is wasteful. If versions of the same data are in different phase of updating, the system gives conflict information. A unique aspect of database design is strong a data only once, which control redundancy and improves system performance.
2.           Ease of learning and use: A major feature of user-friendly database package is how easy it to learn and use. Related to this point is that a database can be modified without interfering with established way of using Free BCA Project data.
3.           Data independence: An important database objective is changing hardware and store procedures or adding new data without having to rewrite application programs.
4.           Performance: This objective emphasizes response time to inquiries suitable to use of the data. How satisfactory the response time is depends on the nature of the user database dialogue.
    





  * The database tables that have been identified for storing data are:
1.       Staff
Attribute Name
Datatype
Feature
EmpId
Varchar(50)
Primary Key
Password
Varchar(30)

Designation
Varchar(30)


2.       Client
Attribute Name
Datatype
Feature
ClientId
Varchar(50)
Primary Key
Password
Varchar(30)

ContactPerson
Varchar(50)

ContactNo
Varchar(11)

Address
Varchar(100)

CompanyName
Varchar(80)


3.       Expenditure
Attribute Name
Datatype
Feature
TransId
Numeric(10)
Primary Key
EventId
Numeric(10)
Foreign Key
ProviderId
Numeric(10)
Foreign Key
EmpId
Varchar(50)
Foreign Key
Amount
Numeric(10)

DateExp
Datetime


4.       EventDesc
Attribute Name
Datatype
Feature
EventId
Numeric(10)
Primary Key
ClientId
Varchar(50)
Foreign Key
Objective
Varchar(300)

Audience
Varchar(50)

TimePeriod
Varchar(10)

Invitation
Varchar(50)

TypeEvent
Varchar(30)

DateEvent
DateTime

Venue
Varchar(100)

Hospitality
Varchar(100)

Performance
Varchar(100)


5.       Estimate
Attribute Name
Datatype
Feature
EventId
Numeric(10)
Foreign Key
EmpId
Varchar(50)

Rate
Numeric(6)

ApproveStatus
Boolean


6.       ServiceProvider
Attribute Name
Datatype
Feature
ProviderId
Numeric(10)
Primary Key
CompanyName
Varchar(100)

Contact
Varchar(50)

ContactNo
Varchar(11)

ServiceType
Varchar(100)

ServiceRate
Numeric(6)

ServiceUnit
Varchar(20)







7.       EventService
Attribute Name
Datatype
Feature
EventId
Numeric(10)
Foreign Key
ProviderId
Numeric(10)
Foreign Key
Expenses
Numeric(10)



8.       Sponsors
Attribute Name
Datatype
Feature
SponsorId
Numeric(10)
Primary Key
SponsorName
Varchar(100)

Product
Varchar(100)


9.       EventSponsor
Attribute Name
Datatype
Feature
EventId
Numeric(10)
Foreign Key
SponsorId
Numeric(10)
Foreign Key
SponsorType
Varchar(15)

SponsorService
Varchar(50)

Revenue
Numeric(10)


10.     PurchaseOrder
Attribute Name
Datatype
Feature
EventId
Numeric(10)
Foreign Key
ProviderId
Numeric(10)
Foreign Key
Description
Varchar(300)

DateDelivery
Datetime

Units
Numeric(10)

Rate
Numeric(10)

Taxes
Numeric(10)

Others
Varchar(20)

OtherRate
Numeric(10)



Attribute Name
Datatype
Feature
ChallanNo
Numeric(10)
Primary Key
EventId
Numeric(10)
Foreign Key
ProviderId
Numeric(10)
Foreign Key
EmpId
Varchar(50)
Foreign Key
ChallanDate
Datetime

Quality
Boolean

Amount
Numeric(10)

AcceptStatus
Boolean

1 comment:

Prince Jose said...

Benefits of earning a Diploma in Event Management & PR include building professional competence, in addition to general leadership, critical thinking, and management skills. Students also gain an understanding of the event project management process and general business-related expertise required to succeed in the industry.
Event Management Courses
Best Event Management Institutes Mumbai

G+

Pages