Käynnissä

normalization project-database

please go through the attachment that I have attached. A nonprofit organization relies on donors for its survival. The organization uses the table below to keep track of donors and their donations. As

seen below, each donor is assigned a unique donor ID.

a. Does the table below meet the properties of a relation? Which if any properties of a relation are violated? (10)

b. What is the normal form of the table below? Why? (10)

c. Create the 3NF relations if this table is not in third normal form? (40)

d. Create an ERD that captures the information requirements from the Donors table. (40)

Donors

Donor

ID

Donor

Name

Donor Contact Donations Publishable Last

Contact

Last

Contacted By

Referrals

100015 Dr. Jon

Mitchell

410 W. Kennedy Blvd

Tampa, FL 33606

[url removed, login to view]

9/1/2012 $1000 Yes 9/12/12 Maria

1000020 Mrs Ricky

Parker

8765 Sheldon Rd

Tampa, FL 33624

(813)792-0954

9/12 $50

5/13 $75

No [url removed, login to view] Maria

100005 Lawrence

Miller

201 2nd Ave

St Petersburg, FL ?????

(727)987-0987 (h)

(605)987-0944(cell)

8/25/08

5/12/08

12/7/07

$100

$75

$100

Yes 25-Jan-13 Tom Mrs Ricky Parker

Jay Parker

Field Descriptions

Column Name Description

DonorID Numeric ID that uniquely describes the donor

DonorName Donor’s full name

DonorContact Donor’s contact information

Donations Date and amount of donations

Publishable Indicates if donor can be identified publicly on the organization’s websited

LastContact Date of last contact with donor

LastContactedBy Employee who had last contact with donor

Referrals Other persons referred by this donor

Taidot: Tietokannan hallinto

Näytä lisää: database normalization project, tom kennedy, jon miller, tom b, ricky c, maria c, lawrence miller, jon h, tampa, survival, ricky, parker, normalization, name jay, mrs, miller, lawrence, erd, ave, database employee, erd normalization, project erd 3nf, erd 3nf, donations form, database project normalization erd

About the Employer:
( 4 reviews ) Falls Church, United States

Projektin tunnus: #4280923

Myönnetty käyttäjälle:

praveen2121

Ready to take this project and complete withing 1 day for sure.

165 $ USD 1 päivässä
(1 arvostelu)
2.4

2 freelanceria on tarjonnut keskimäärin 168 $ tähän työhön

extreamcode

HI, Expert here, let's discuss and get started. Let me know if you have any questions. Please check our portfolio here: [url removed, login to view] looking forward to hear from you soon. thanks, DT

170 $ USD 20 päivässä
(0 arvostelua)
0.0