|
Entities |
Attributes |
|
Award |
DonorCircle, DPhoneNumber, PDonorPhone, AmountPaid |
|
Donor |
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 |
|
|
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.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more