Ask a question to Desklib · AI bot

Ask NowBETA

Show the ER diagram for your database.

5 Pages510 Words454 Views
   

Added on  2019-09-23

BookmarkShareRelated Documents
Show the ER diagram for your database. There should be at least 4 entities with their relations. Clearly describe and explain all the symbols you use for your ER diagram.OrganisationOrganisationId - Unique Id for each organisationOrganisationName - Name of the organisationOrganisationAddress - Address of the organisationOrganisationContact - Contact Number of organisationOrganisationDescription - Organisation descriptionOrganisationStatus - Status of the organisation like active or non-active to take donation further Donor
Show the ER diagram for your database._1
DonorId - Unique Id for each donorDonorName - Name of the donorDonorEmail - Email of the donor to send emailDonorContact - Contact number of donorDonorAddress - Address of the donorDonationDonationId - Unique Id for each donation madeDonorId - Donor Id who made the donationOrganisationId - Organisation Id for which donation is madeDonationAmount - Donation amount donated by donorDonationDate - Donation date on which donation is madeIsAnonymous - Yes, if donor wants to be anonymous else noThankyouLetterStatus - Sent, if mail has been sent to donor else penidngDonationAmountOrganisationId - Organisation Id for which data is storedTotalAmountReceived - Total donation received by the organisationTotalAmountTransferred - Total donation transferred by DonationDollar by nowTotalAmountPending - Total donation pending to be transferred by DonationDollarDonationDollarFees - Fees earned by DonationDollar till nowShow the corresponding Relational ModelOrganisation
Show the ER diagram for your database._2

Found this document preview useful?

Related Documents
ICT40115 - Certificate IV in Information Technology
|10
|741
|216

Term Project ERD
|7
|684
|295

Employee Database: ER Diagram, Table Commands, Sample Data, SQL Queries
|15
|704
|88

H16W 35 Relational Database Management Systems
|16
|1641
|138

Assessment | Database Modelling (KC7013)
|18
|2655
|30

International Journal of Pure and Applied Mathematics
|12
|1273
|26