Questions from Database Systems

Q: Create a sample XML document and DTD for the exchange of student

Create a sample XML document and DTD for the exchange of student transcript data. Use your college transcript as a sample.

Q: Use MS Excel to connect to the Ch02_InsureCo MS Access

Use MS Excel to connect to the Ch02_InsureCo MS Access database using ODBC, and retrieve all of the CUSTOMERs.

Q: Use MS Excel to connect to the Ch02_InsureCo MS Access

Use MS Excel to connect to the Ch02_InsureCo MS Access database using ODBC, and retrieve the customers whose AGENT_CODE is equal to 503.

Q: Create a System DSN ODBC connection called Ch02_SaleCo using the

Create a System DSN ODBC connection called Ch02_SaleCo using the Administrative Tools section of the Windows Control Panel.

Q: Use MS Excel to list all of the invoice lines for Invoice

Use MS Excel to list all of the invoice lines for Invoice 1003 using the Ch02_SaleCo System DSN.

Q: Create a System DSN ODBC connection called Ch02_TinyCollege using the

Create a System DSN ODBC connection called Ch02_TinyCollege using the Administrative Tools section of the Windows Control Panel.

Q: Use MS Excel to list all classes taught in room KLR200 using

Use MS Excel to list all classes taught in room KLR200 using the Ch02_TinyCollege System DSN.

Q: Create a sample XML document and DTD for the exchange of customer

Create a sample XML document and DTD for the exchange of customer data.

Q: Create a sample XML document and DTD for the exchange of product

Create a sample XML document and DTD for the exchange of product and pricing data.

Q: Write a query to count the number of customers with a customer

Write a query to count the number of customers with a customer balance over $500. FIGURE P7.26 THE CH07_SALECO DATABASE