DFD (Data flow diagram) of Free BCA Project event management systme
Free BCA PROJECT # 1 ONLINE EXAMINATION SYSTEM
FRONT END - ASP.NET, C#
BACK END - SQL SEVER 2007
Click here to Downlaod Project SYNOPSIS OF ONLINE EXAMINATION SYSTEM
FREE BCA PROJECT # 2- HOSPITAL INFORMATION SYSTEM
FRONT END - VB6.0BACK END - SQL SEVER 2000
Click here to download SYNOPSIS of Project Sanatorium (Hospital Information System)
Free downlaod Final report of project Hospital Information 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 DOWNLOAD PROJECT SYNOPSIS OF MEDICAL & SURGICAL SUPPLIERS
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
DFD '2' Level
Entity Relationship Diagram ER Diagram
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:
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
Post a Comment