Homework 10

Create an XML file that’s the equivalent of this database. Enter some data – let’s say 2 racetracks, 8 horses, 10 races, and 15 results. The data can be real or fictional.

RaceTrack(TrackName, City, State)

Horse(HorseName, YearBorn, Gender)

Race(RaceID, Distance, TrackName, Date, RaceNumber, Condition)

Result(RaceID, HorseName, Time, Place)

Most of these field names are self-explanatory. Distance is a number between 6 and 10. RaceNumber is an integer between 1 and 10. Condition is either Excellent, Good, Muddy, or Wet. Time is the time it took a horse to run a race (for example, 1:39). Place is an integer between 1 and 20 (1 is first place, 2 is second place, etc.)

Create a DTD file to define your XML file. Your DTD file must “sort of” define primary and foreign key restraints using attributes. The original primary keys (like TrackName) should be nodes. So you'll also need to have attributes for the primary and foreign keys.

Email me a zip of your xml and dtd files.