Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started