Topic: Database **Transcription:**Create a sample XML document that implements the conceptual data model expressed in UML and shown below. Invent 5-10 instances that allow you to demonstrate the structure. Create an appropriate internal DTD. This is a specific set of instances -- you can come up with them as you see fit. Be sure to view the XML to ensure it validates.**Diagram Explanation:**1. **Room Entity:** - Attributes: - `name: id` - `length` - `width` - Relationship: A Room is associated with one or more Furnishings.2. **Furnishing Entity:** - Attributes: - `id: id` - `type` - Relationship: A Furnishing can be related to one or more Manufacturers.3. **Manufacturer Entity:** - Attributes: - `id: id` - `name` - `contact` - Relationship: A Manufacturer is associated with one or many Furnishings.**Relationships:**- There is a one-to-many relationship (1 to 0..*) from Room to Furnishing.- There is a one-to-many relationship (1 to 1..*) from Furnishing to Manufacturer. This diagram represents a structured way to model room furnishings and their manufacturers using a conceptual data model.

The entities along with attributes in the given UML are as follows. Room ( name, length, width ) Furnishing ( id, type ) Manufacturer ( id, name, contact ) The primary key is underlined in each entity. The XML coding for individual entity is as follows. Room entity <xs:element name="Room"> <xs:complexType> <xs:sequence> <xs:element name="name" type="xs:string"/> <xs:element name="length" type="xs:positiveInteger"/> <xs:element name="width" type="xs:positiveInteger"/> </xs:sequence> </xs:complexType></xs:element> Furnishing entity <xs:element name="Furnishing"> <xs:complexType> <xs:sequence> <xs:element name="id" type="xs:positiveInteger"/> <xs:element name="type" type="xs:string"/> </xs:sequence> </xs:complexType></xs:element> Manufacturer entity <xs:element name="Manufacturer"> <xs:complexType> <xs:sequence> <xs:element name="id" type="xs:positiveInteger"/> <xs:element name="name" type="xs:string"/> <xs:element name="contact" type="xs:positiveInteger"/> </xs:sequence> </xs:complexType></xs:element> The XML schema is as follows. <?xml version = "1.0" encoding = "UTF-8"?> <xs:schema xmlns:xs = "http://www.w3.org/2001/XMLSchema"><xs:element name="Room"> <xs:complexType> <xs:sequence> <xs:element name="name" type="xs:string"/> <xs:element name="length" type="xs:positiveInteger"/> <xs:element name="width" type="xs:positiveInteger"/> </xs:sequence> </xs:complexType></xs:element><xs:element name="Furnishing"> <xs:complexType> <xs:sequence> <xs:element name="id" type="xs:positiveInteger"/> <xs:element name="type" type="xs:string"/> </xs:sequence> </xs:complexType></xs:element><xs:element name="Manufacturer"> <xs:complexType> <xs:sequence> <xs:element name="id" type="xs:positiveInteger"/> <xs:element name="name" type="xs:string"/> <xs:element name="contact" type="xs:positiveInteger"/> </xs:sequence> </xs:complexType></xs:element></xs:schema> The internal DTD is as follows. <?xml version = "1.0" encoding = "UTF-8" standalone = "yes" ?> <!DOCTYPE Sample [ <!ELEMENT Room (name,length,width)> <!ELEMENT Furnishing (id, type)> <!ELEMENT Manufacturer (id, name, contact)> ]> <Room name = "bedroom"> <length>150</length> <width>150</width></Room> <Room name = "diningroom"> <length>100</length> <width>100</width></Room> <Room name = "livingroom"> <length>150</length> <width>150</width></Room> <Room name = "restroom"> <length>50</length> <width>50</width></Room> <Room name = "nursery"> <length>50</length> <width>50</width></Room> <Furnishing id = 1> <type>"modern"</type></Furnishing><Furnishing id = 2> <type>"traditional"</type></Furnishing><Furnishing id = 3> <type>"fusion"</type></Furnishing><Furnishing id = 4> <type>"ultramodern"</type></Furnishing><Furnishing id = 5> <type>"minimalist"</type></Furnishing> <Manufacturer name = 101> <name>"Modern company"</name> <contact>800-123-4567</contact></Manufacturer><Manufacturer name = 102> <name>"Sunrise company"</name> <contact>800-456-7890</contact></Manufacturer><Manufacturer name = 103> <name>"RisingStar company"</name> <contact>800-789-1234</contact></Manufacturer><Manufacturer name = 104> <name>"ThreeBrothers company"</name> <contact>800-522-6578</contact></Manufacturer><Manufacturer name = 105> <name>"Wellness company"</name> <contact>800-456-0459</contact></Manufacturer> -