blitz

For This or a Similar Paper Click Here To Order Now

Database Connectivity and Web Technologies
Questions: Use MS Excel to connect to the Ch02_InsureCo MS Access database using ODBC, and retrieve all of the AGENTs.
(Example: ch15_problem1_Jones.xls)
Use MS Excel to connect to the Ch02_InsureCo MS Access database using ODBC, and retrieve all of the CUSTOMERs.
(Example: ch15_problem1_Jones.xls)
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.
(Example: ch15_problem1_Jones.xls)
Create a System DSN ODBC connection called Ch02_SaleCo using the Administrative Tools section of the Windows Control Panel.
(Example: ch15_problem1_Jones.xls)
Use MS Excel to list all of the invoice lines for Invoice 103 using the Ch02_SaleCo System DSN.
(Example: ch15_problem1_Jones.xls)
Create a System DSN ODBC connection called Ch02_Tinycollege using the Administrative Tools section of the Windows Control Panel.
(Example: ch15_problem1_Jones.xls)
Use MS Excel to list all classes taught in room KLR200 using the Ch02_TinyCollege System DSN.
(Example: ch15_problem1_Jones.xls)
Create a sample XML document and DTD for the exchange of customer data. Use Section 15-3a as your guide.
(Example: ch15_problem1_Jones.doc)
Create a sample XML document and DTD for the exchange of product and pricing data. Use Section 15-3a as your guide.
(Example: ch15_problem1_Jones.doc)
Create a sample XML document and DTD for the exchange of order data. Use Section 15-3a as your guide.
(Example: ch15_problem1_Jones.doc)
Create a sample XML document and DTD for the exchange of student transcript data. Use your college transcript as a sample. Use Section 15-3a as your guide.
(Example: ch15_problem1_Jones.doc)

 

📌 Struggling with where to start this assignment? Follow this guide to tackle your assignment easily!

This assignment focuses on database connectivity using ODBC (Open Database Connectivity) and working with XML and DTD to exchange data. You’ll be using MS Excel to retrieve data from an MS Access database and create XML documents for structured data exchange. Follow these steps carefully:

---

🖥️ Part 1: Connecting MS Excel to an MS Access Database via ODBC

Step 1: Set Up ODBC Connection

Before retrieving data, you need to create an ODBC connection to the MS Access database.

1. Open Windows Control Panel → Go to Administrative Tools → Open ODBC Data Sources (32-bit or 64-bit)
2. Click on the “System DSN” tab → Select Add
3. Choose Microsoft Access Driver (.mdb, .accdb)
4. Enter the Data Source Name (DSN):
   • For the first part, name it Ch02_InsureCo
   • For the other parts, use Ch02_SaleCo and Ch02_TinyCollege
5. Click Select and browse to find the Ch02_InsureCo.mdb file.
6. Click OK to save the connection.

---

Step 2: Retrieve Data in MS Excel

Once the ODBC connection is set up, follow these steps:

1. Open MS Excel
2. Go to Data → Get Data → From Other Sources → From ODBC
3. Select the Ch02_InsureCo DSN
4. Choose the AGENT table → Click Load
5. Save the file as ch15_problem1_YourName.xls

✅ Repeat the same process to retrieve:

• All CUSTOMERS
• Customers with AGENT_CODE = 503 (Apply a filter after importing)
• Invoice lines for Invoice 103 (Ch02_SaleCo DSN)
• Classes taught in room KLR200 (Ch02_TinyCollege DSN)

---

📜 Part 2: Creating XML Documents with DTD

Now, you will create XML (Extensible Markup Language) documents and DTD (Document Type Definition) files to structure different types of data.

Step 1: Understanding XML Structure

XML is used to store and exchange data in a structured format. A DTD file defines the structure of the XML document.

Step 2: Create XML and DTD for Customer Data

1. Open Notepad or XML Editor (e.g., Notepad++).
2. Create a new XML file:

3. Create a DTD file (customers.dtd):

4. Save both files as ch15_problem1_YourName.xml and ch15_problem1_YourName.dtd

✅ Repeat the same process to create XML and DTD files for:

• Product and Pricing Data
• Order Data
• Student Transcript Data

---

📌 Final Submission Checklist

✅ MS Excel files: Retrieve AGENTS, CUSTOMERS, filtered CUSTOMERS, invoices, and classes
✅ System DSN ODBC connections: Ch02_InsureCo, Ch02_SaleCo, Ch02_TinyCollege
✅ XML & DTD files: Customer data, product pricing, orders, student transcripts
✅ Correct filenames: ch15_problem1_YourName.xls and ch15_problem1_YourName.doc

By following these steps carefully, you’ll successfully complete the assignment. 🚀 Good luck! 💡

For This or a Similar Paper Click Here To Order Now

WRITE MY ESSAY