School of Engineering Technology

Applied Database $1$

COP $4708$

Assignment # $3$

Assignment Objective: The goal of this assignment is to develop database model and database design

that will assist in understanding the relational database. Before we start the coding we need to create a

model that represents the database then convert it into database design. This assignment will measure

student learning outcome number $2$

Introduction: You were hired as a consultant to assist in the construction of an efficient database for a

non$-$profit foundation. As a consultant you were able to identify four major entities in the organization

system. The entities are Donor, Donation, Events and Projects. You also identified each entities$$ attributes

and functional dependencies as shown below.

$$ Donations

DonationID

Amount

Date

TransactionNum

DonorID

ProjectID

EventID

$$ Donors

DonorID

FirstName

LastName

StreetAddress

City

State

ZipCode

PhoneNumber

Email

$$ Projects

ProjectID

Type

Name

Location

Duration

DateOfFunding

AmountOfFunding

CompletionDate

$$ Events

EventID

Description

Location

Date

Sponsor

EventFundingGoal

CollectedFunds

Functional dependencies:

Donor

$($DonorID$)($FirstName$,$ LastName, StreetAdd, City, State, ZipCode, Phone, Email$)$

$($ZipCode$)($City$,$ State$)$

$($Email$)($FirstName$,$ LastName, StreetAdd, City, State, ZipCode, Phone$)$

$($Phone$)($FirstName$,$ LastName, StreetAdd, City, State, ZipCode, email$)$

Donations

$($DonationID$)($DonationAmt$,$ DonationType, DonationCCNum, DonatCCExpDate, ProjectID,

DonorID$)$

Projects

$($ProjectID$)($ProjectType$,$ ProjectName, ProjectLocation, ProjectDuration, FundingDate,

FundingAmt, CompleteDate$)$

Events

$($EventID$)($ProjectID$,$ EventDescription, EventLocation, EventDate, Sponsor,

EventFundGoal, CollectedFunding$)$

In addition, you had an interview with the nonprofit organization director to understand more about the

database and entity relationships. The director said: "The fundraising or donations can be through donors

or through events. One donor can make recurrent donations or one time donation, which means that a

donation must have a donor but a donor does not have to donate always. If donations are not enough an

event will be initiated. Usually the collected donation will support one project or several projects. So a

project must be supported by a donation, and donations have to be used for projects."

Note: this interview will assist in defining the maximum and minimum cardinalities $($relationships$).$

Requirement:

Based on the given information above create a Data Model and a Database Design, remember that the

Data Model will include entities, their attributes, ad their relationships. In the Database Design the entities

will be converted to tables, identifiers to primary keys, and attributes to columns. Relationships will be

verified both maximum and minimum cardinality. In addition, you will add data type, data size, the

primary keys, the foreign key, and the null$/$not null constraints. You can use any software to create your

data model and data base design. After done creating both diagram, copy those diagram and paste them in

a MS Word Document as indicated in previous lectures. This will assist in understanding data schema and

entity relationship diagrams.