Database Reference
In-Depth Information
Figure 11-65
HtML Modifications for the
index.html File in the VrG
Folder
11.119
Microsoft expends much effort to promote the .NET Framework. It does not di-
rectly receive revenue from these standards. IIS is free with Windows 7, Windows 8,
Windows Server 2008 R2, and now Windows Server 2012. Microsoft's Web sites have
numerous articles to help developers learn more about these standards, and all of the
information is free. Why do you think Microsoft does this? What goal is served?
11.120
Create an XML Schema Document for a row of the ARTIST table. Use only simple ele-
ments, and use Figure 11-52 as an example.
11.121
Create an XML Schema document for a row of TRANS. Place TransactionID as an
attribute. Group acquisition data into a complexType, and group sales data into a sec-
ond complexType. Use Figure 11-53 as an example.
11.122
Create an XML Schema for artists and the customers who are interested in them. Use
Figure 11-58 as an example.
Create an XML Schema for artist, work, transaction, and customer data. Use Figure 11-60
as an example, and include your answer to Project Question 11.122 in the schema.
11.123
11.124
Create an XML Schema for all artist data. Use Figure 11-61 and your answer from
Project Question 11.123.
11.125
Write an SQL statement with FOR XML that will produce the document you created
in Review Question 11.122 (
Hint
: Figure 11-59).
Marcia's Dry Cleaning Case Questions
If you have not already done so, create and populate the Marcia's Dry Cleaning (MDC) data-
base for the DBMS you are using as described in:
●
Chapter 10A for Microsoft SQL Server 2012
●
Chapter 10B for Oracle Database 11
g
Release 2
●
Chapter 10C Oracle MySQL 5.6
A.
Add a new folder to the DBP Web site named MDC. Create a Web page for Marcia's Dry
Cleaning in this folder, using the file name
index.html
. Link this page to the DBP Web page.
B.
Create an appropriate ODBC data source for your database.
Search WWH ::
Custom Search