Beta University Annual Fund: Fundraising And Donation Management

Entities Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper	Attributes
Award	DonorCircle, DPhoneNumber, PDonorPhone, AmountPaid
Donor Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper	DPhoneNumber, DonorName, DonorAddress, Donor Email, Category, YearOfGraduation, PledgingID, EventID, IsPotentialDonor
PledgingDetails	PleadgingID, DateOfPledging, AmountPledged, AmountEnclosed, NumberOfPaymets, PaymentMethod, CCN_NUM, CorporationName, CorprationAddress, SpouseName
Events	EventID, TypeOfEvent, Organized Date
VolunteerDetails	VID, Volunteername, VolunteerAddress, VPhoneNum, VEmail
ClassCoordinator	CoordinatorID, CoordinatorName, CordinatorAddress, Email, PhoneNumber, YearOfGraduation
PhonathonDonor	PDonorPhone, VID, PDonorName, PDonorAddress, DonorCategory, GraduationYear, LastYearPledge, CurrentPledge

Table1: Defining Entities and Attributes

Relation In Between	Relationship Type
Donor has a relation with PledgingDetails	One to one relationship
Donor has a relationship between Award	One to one relationship
Award has a relationship with PhonathonDonor	One to many relationship
ClassCoordinator has a relationship with Donor	One to many relationship
Event has a relationship with Donor	One to many relationship
Event has a relationship with VolunteerDetails	One to many relationship
Event has a relationship with ClassCoordinator	One to many relationship

Figure 1: Showing ERD of BETA UNIVERSITY

Data Dictionary and assumptions

Underline is denotes primary key whereas, italics denotes foreign key

Attribute	Data type	type	Value
DonorCircle	varchar	Not null	30
DPhoneNumber	int	Not null	10
PDonorPhone	int	Not null	10
AmountPaid	int	Not null	10
DPhoneNumber	int	Not null	10
DonorName	varchar	Not null	30
DonorAddress	varchar	Not null	50
Donor Email	varchar		30
Category	varchar	Not null	30
YearOfGraduation	date as (mm/dd/yyyy)
PledgingID	int	Not null	10
EventID,	int	Not null	10
IsPotentialDonor	varchar as Y or N	Not null	1
EventID	int	Not null	10
TypeOfEvent	varchar	Not null	30
Organized Date	date as (mm/dd/yyyy)	Not null
VID	int	Not null	10
Volunteername	varchar	Not null	30
VolunteerAddress	varchar	Not null	50
VPhoneNum	int	Not null	10
VEmail	varchar		30
CoordinatorID	int	Not null	10
CoordinatorName	varchar	Not null	30
CordinatorAddress	varchar	Not null	50
Email	varchar		30
PhoneNumber	int	Not null	10
YearOfGraduation	date as (mm/dd/yyyy)	Not null
PDonorPhone	int	Not null	10
VID	int	Not null	10
PDonorName	varchar	Not null	30
PDonorAddress	varchar	Not null	50
DonorCategory	varchar	Not null	15
GraduationYear	date as (mm/dd/yyyy)	Not null
LastYearPledge	int		10
CurrentPledge	int		10
PleadgingID	int	Not null	10
DateOfPledging	date as (mm/dd/yyyy)	Not null
AmountPledged	int	Not null	10
AmountEnclosed	int	Not null	10
NumberOfPaymets	int	Not null	10
PaymentMethod	varchar	Not null	15
CCN_NUM	int	Not null	16
CorporationName	varchar		30
CorprationAddress	varchar		50
SpouseName	varchar		30

Table 2: Showing Data Dictionary and Data Assumption

Achpal, A., Kumar, V. B., & Mahesh, K. (2016). Modeling Ontology Semantic Constraints in Relational Database Management System. In Proceedings of the International MultiConference of Engineers and Computer Scientists (Vol. 1).

Arasu, A., Babcock, B., Babu, S., Cieslewicz, J., Datar, M., Ito, K., … & Widom, J. (2016). Stream: The stanford data stream management system. In Data Stream Management (pp. 317-336). Springer, Berlin, Heidelberg.

Coronel, C., & Morris, S. (2016). Database systems: design, implementation, & management. Cengage Learning.

Deelman, E., Vahi, K., Juve, G., Rynge, M., Callaghan, S., Maechling, P. J., … & Wenger, K. (2015). Pegasus, a workflow management system for science automation. Future Generation Computer Systems, 46, 17-35.

Gubanov, M., Jermaine, C., Gao, Z., & Luo, S. (2016). Hybrid: A large-scale linear-relational database management system. In MIT Annual DB Conference.

Hababeh, I., Khalil, I., & Khreishah, A. (2015). Designing high performance web-based computing services to promote telemedicine database management system. IEEE transactions on services computing, 8(1), 47-64.

Nidzwetzki, J. K., & Güting, R. H. (2016). DISTRIBUTED SECONDO: An extensible highly available and scalable database management system. FernUniversität, Fakultät für Mathematik und Informatik.

Prout, A., Kepner, J., Michaleas, P., Arcand, W., Bestor, D., Bergeron, B., … & Mullen, J. (2015, September). Enabling on-demand database computing with MIT SuperCloud database management system. In High Performance Extreme Computing Conference (HPEC), 2015 IEEE (pp. 1-6). IEEE.

Turn in your highest-quality paper
Get a qualified writer to help you with

“ Beta University Annual Fund: Fundraising And Donation Management ”

Get high-quality paper

NEW! AI matching with writer