Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

XML /donors.txt Founding Circle Donors =================== David Brennan 5133 Oak Street Windermere, FL 34786 (407) 555-8981 home (407) 555-8189 cell dbrennan@example.net $50,000 Method: phone EffectiveDate:

XML

image text in transcribed

/donors.txt

Founding Circle Donors ===================

David Brennan 5133 Oak Street Windermere, FL 34786 (407) 555-8981 home (407) 555-8189 cell dbrennan@example.net $50,000 Method: phone EffectiveDate: 9/1/1982

Cindy Wu 31 Alice Avenue Windermere, FL 34786 (407) 555-7212 home cwu@example.net $50,000 Method: phone EffectiveDate: 9/1/1982

Sponsorship Donors ================

David Olson 5133 Oak Street Windermere, FL 34786 (407) 555-8981 home (407) 555-8189 cell dolson@example.net $25,000 Method: personal EffectiveDate:7/3/1985

Wilmer Stonehedge 31 Alice Avenue Windermere, FL 34786 (407) 555-7212 cell wstone@example.net $25,000 Method: personal EffectiveDate: 10/3/1994

Patron Donors ============

Lee Unwin 451 Unwin Ct. Orlando, FL 32801 (407) 555-9082 cell leeunwin@example.net $18,000 Method: personal EffectiveDate: 11/1/1998

Jane Whitney 87 Hilltop Drive Windermere, FL 34786 (407) 555-7493 work $15,000 Method: personal EffectiveDate: 11/1/1998

Andrew Sanchez 891 Lindon Lane Windermere, FL 34786 (407) 555-4313 cell asanchez@example.com $15,000 Method: personal EffectiveDate: 3/4/2000

Friendship Donor ===============

Gary Windt 55 Hawking Street Windermere, FL 34786 (407) 555-9939 home windtg@example.com $1000 Method: phone Effective Date: 3/4/2000

Cynthia Browne 71 Circuit Ct. Wheaton, KY 89321 (407) 555-3813 cell cynthia@example.com $1000 Method: phone Effective Date: 3/4/2000

Howard Li 4312 East Oak Avenue Youngston, KY 89318 (407) 555-3921 home $1000 Method: mail Effective Date: 3/4/2011

Uma Thu 25 Longton Lane Windermere, FL 34786 (407) 555-8730 cell $1000 Method: personal Effective Date: 4/4/2012

Alan Wilkes 321 Ashburn Jasper, KY 89831 (407) 555-1181 home wilkes_alan@example.edu $500 Method: mail Effective Date: 1/4/2012

Steve Bones 900 Lawton Street Wheaton, KY 89211 (407) 555-5434 cell $500 Method: personal Effective Date: 9/14/2012

Jeri White Hawkes Lane Windermere, FL 89211 (407) 555-8828 cell jeri_white@example.com $300 Method: phone Effective Date: 12/4/2012

Tom Thomas Rigel Avenue Apopka, FL 32703 (407) 555-8311 home $100 Method: phone Effective Date: 2/4/2012

//rostertxt.xml

//seatrussttxt.dtd

Case Problem 3 Data Files needed for this Case Problem: donors.txt, rostertxt.xml, seatrusttxt.dtd Note: To complete this case problem, you need an XML parser capable of validating an XML document based on an external DTD file, such as Exchanger XML Editor. The Save Exotic Animals Trust Sienna Woo is the donor coordinator for the Save Exotic Animals Trust (SEA Trust), a charitable organization located in central Florida. One of her responsibilities is to maintain a membership list of people in the community who have donated to SEA Trust. Donors can belong to one of four categories-Friendship, Patron, Sponsor, or Founder. The categories assist Sienna in marketing SEA Trust's fundraising goals and in developing strategies to reach those goals. Currently, most of the data that Sienna has compiled resides in text files. To make the fundraising campaign strategies more effective, she wants to convert this data into an XML document and ensure that the resulting document follows some specific guidelines. You will create the XML document for her Complete the following 1. Using your text editor, open the rostertxt.xml and seatrusttxt.dtd files from the xmlo2 case3 folder provided with your Data Files, insert your name and today's date in the comment section of each file, and then save the files as roster.xml and seatrust.dtd, respectively 2. Add the data stored in the donors.txt file in the xmlo2 case3 folder to the roster.xml file as the document content, and then add XML elements to structure the data in the roster.xml file as follows Note: You should ignore any validation or well-formedness errors flagged by your editor until the document is finished.) a. A root element named roster should contain several donor elements b. Each donor element should contain the following child elements, which should appear no more than once within the donor element, except as noted-name, address, phone (one or more), email (optional), donation, method, and effectiveDate c. The phone element should contain an attribute named type that identifies the phone type_ home, work, or cell. This should be a required attribute for each phone element. d. The donor element should contain an attribute named level that identifies the donor level friendship, patron, sponsor, or founder. This should be a required attribute for each donor element 3. In the seatrust.dtd file, create a DTD based on the structure you created in the roster.xml file Save and close the seatrust.dtd file. 4. Apply your DTD to the contents of the roster.xml file. Save your changes to the roster.xml file 5. Verify that the roster.xml file is well formed and valid

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

Database Processing Fundamentals Design

Authors: Marion Donnie Dutton Don F. Seaman

14th Edition Globel Edition

1292107634, 978-1292107639

More Books

Students also viewed these Databases questions