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 them as you see fit. Be sure to view the XML to ensure it validates. Room Manufacturer Furnishing id: id name: id 1.* id: id length width 0.* name type contact

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

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.
Transcribed Image Text:**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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education