Database Management System of Beta University Assignment
Added on 2021-04-17
6 Pages869 Words167 Views
Running head: DATABASE MANAGEMENT SYSTEM OF BETA UNIVERSITYDatabase Management System of Beta UniversityName of Student-Name of University-Author’s Note-
1DATABASE MANAGEMENT SYSTEM OF BETA UNIVERSITY3.1 List of all entities and their associated attributesEntitiesAttributes AwardDonorCircle, DPhoneNumber, PDonorPhone, AmountPaidDonorDPhoneNumber, DonorName, DonorAddress, Donor Email,Category, YearOfGraduation, PledgingID, EventID,IsPotentialDonorPledgingDetailsPleadgingID, DateOfPledging, AmountPledged, AmountEnclosed,NumberOfPaymets, PaymentMethod, CCN_NUM,CorporationName, CorprationAddress, SpouseNameEventsEventID, TypeOfEvent, Organized DateVolunteerDetailsVID, Volunteername, VolunteerAddress, VPhoneNum, VEmailClassCoordinatorCoordinatorID, CoordinatorName, CordinatorAddress, Email,PhoneNumber, YearOfGraduationPhonathonDonorPDonorPhone, VID, PDonorName, PDonorAddress, DonorCategory,GraduationYear, LastYearPledge, CurrentPledgeTable1: Defining Entities and Attributes3.2 List of relationships to be represented, and descriptive attributesRelation In BetweenRelationship TypeDonor has a relation with PledgingDetailsOne to one relationshipDonor has a relationship between AwardOne to one relationshipAward has a relationship withPhonathonDonorOne to many relationshipClassCoordinator has a relationship withDonorOne to many relationshipEvent has a relationship with DonorOne to many relationshipEvent has a relationship withVolunteerDetailsOne to many relationshipEvent has a relationship withClassCoordinatorOne to many relationship3.3 ER Diagram of Beta University
2DATABASE MANAGEMENT SYSTEM OF BETA UNIVERSITYDonorPledgingDetailsEventsClassCoordinatorPhonathonDonorVolunteerDetailsAwardDPhoneNumberPKDonorNameDonorAddressDonor EmailCategoryYearOfGraduationPledgingIDFKPleadgingIDPKDateOfPledgingAmountPledgedAmountEnclosedNumberOfPaymetsPaymentMethodCCN_NUMCorporationNameCorprationAddressSpouseNameEventIDPKOrganized DateTypeOfEventEventIDFKCoordinatorIDPKCoordinatorNameCordinatorAddressEmailPhoneNumber YearOfGraduationIsPotentialDonorPDonorPhonePKPDonorNamePDonorAddressDonorCategoryGraduationYearLastYearPledgeCurrentPledgeVIDPKVolunteernameVolunteerAddressVPhoneNumVEmailDonorCirclePKPDonorPhoneFKDPhoneNumberFKAmountPaidVIDFKFigure 1: Showing ERD of BETA UNIVERSITYStep 3.4 Data dictionary and list of assumptionsData Dictionary and assumptionsUnderline is denotes primary key whereas, italics denotes foreign keyAttribute Data type typeValue DonorCirclevarcharNot null30DPhoneNumberintNot null10PDonorPhoneintNot null10AmountPaidintNot null10DPhoneNumberintNot null10DonorNamevarcharNot null30
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
H16W 35 Relational Database Management Systemslg...
|16
|1641
|138
Rationale & Assumptionlg...
|11
|1212
|460
Assignment about What is Database Design and Development?lg...
|8
|790
|32