Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please Help! Need this in SQL ASAP: They have requested the development of a database that will be used to track the donations made to

Please Help! Need this in SQL ASAP:

They have requested the development of a database that will be used to track the donations made to the organization. These donations come in the form of tangible donations (pieces of art) and in monetary form. Using the unnormalized data on the attached spreadsheet, construct a relational database in third normal form that will allow OSUIT to keep records on their donors (and potential donors), the items they have donated, and the individuals (and potential individuals) that are maintaining the tangible donations.

Assumptions and requirements:

Each tangible donation (piece of art) is unique. More than one caretaker can maintain each piece as illustrated in columns G through J.

Any row on the unnormalized spreadsheet with just caretaker information is an individual interested in taking care of art, but is not yet doing so.

Any row on the unnormalized spreadsheet with just donor information is an individual that contributed funds or may contribute funds (prospective donor) to OSUIT but not art.

Do not alter any of the data or the way the data is structured within each cell

Here is the information needed for the database:

Donor Name Donor Address Donated Money? Art Name Art Type Art Appraised Price Art Caretaker Caretaker Contact Art Caretaker Caretaker Contact
Ronald McDonald 123 Katsup Circle N French or Freedom? Sculpture 199.95 Shelly Stevenson x4432 David Stenton x5123
Ronald McDonald 123 Katsup Circle N Shake the Shake Sculpture 495.01 William Svenson x1337
Rusty Pickens 234 Windmill Lane Y
Donald Duck 456 Waterton Road Y 1, 2, 3, Happy! Painting 1249.99 David Stenton x5123 Richard Cheney x6666
Donald Duck 456 Waterton Road Y Treatise on Western Civilization Manuscript 999.95
Donald Duck 456 Waterton Road Y Ethical Ramifications of a Vegan Diet Sculpture 998.95 Shelly Stevenson x4423 David Stenton x5123
Mickey Mouse 567 Happy Hills Lane Y Disney's Steamboat Willy Film 111000.99
Fil Guinn 678 Okmulgee Drive N
Pam Ingham x5842
Michael Hass x5843

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Temporal Databases Research And Practice Lncs 1399

Authors: Opher Etzion ,Sushil Jajodia ,Suryanarayana Sripada

1st Edition

3540645195, 978-3540645191

More Books

Students also viewed these Databases questions

Question

Ensure continued excellence in people management.

Answered: 1 week ago