Consider Date\'s supplier and parts database. Construct the following: a. A DTD

Question

Consider Date's supplier and parts database. Construct the following:

a. A DTD for the Parts relation. This describes the schema, or relation definition.

b. XML for the data in the Parts relation. This describes the actual data contained in the relation

THE SUPPLIERS-AND-PARTS DATABASE: S SNOSNAMES STATUS CITY SP SNOPNOQTY S1P1 300 S1P2200 S1Smith S2|Jones S3Blake S4 Clark S5 Adams 20 London 10 Paris 30 Paris 20 London 30 Athens P2200o 400 S1P4 200 100 S1 P6 100 300 400 P2200 P2 200 S4P4 300 400 S1 P3 S1P5 S2 P1 S2P2 S3 P S4 P P PNO PNAMECOLOR WEIGHTCITY P1Nut P2Bolt P3 Screw P4Screw P5 Cam P6Cog Red Greer Blue Red Blue Red 12.0 London 17.0 Paris 17.0 Oslo 14.0 London 12.0Paris 19.0London S4 P5

Explanation / Answer

DTD for the Parts relation:

a).The schema, or relation definition

<!ELEMENT P (PARTS)*>

<!ELEMENT PARTS (PNO,PNAME, COLOR, WEIGHT, CITY)>

<!ELEMENT PNO(#PCDATA)>

<!ELEMENT PNAME(#PCDATA)>

<!ELEMENT COLOR (#PCDATA)>

<!ELEMENT WEIGHT (#PCDATA)>

<!ELEMENT CITY (#PCDATA)>

b. XML for the data in the Parts relation. This describes the actual data contained in the relation

(OR)

SCHEAM AND XML for the DATA in the Parts relation IN ONE FILE

<!ELEMENT PARTS (PNO,PNAME, COLOR, WEIGHT, CITY)>

<!ELEMENT PNO(#PCDATA)>

<!ELEMENT PNAME(#PCDATA)>

<!ELEMENT COLOR (#PCDATA)>

<!ELEMENT WEIGHT (#PCDATA)>

<!ELEMENT CITY (#PCDATA)>

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.