Scenario: Consider an online company (e.g., a bookstore) that keeps track of its resources in
a database. For a bookstore, these would be information about books such as author names, book
titles, customers who buy books, etc. This company has some sister Web companies with whom it
exchanges information about its resources. However, the company does not want to give access to
its database when sharing information. Hence, it takes the data from its database and creates a ﬁle
of information and sends that to the other companies. The company creates this ﬁle and sends it to
the other companies if the other companies request it.
The possible companies are the following. Feel free to choose one or to invent one if you like.
Bookstore, Web site providing calender services, Web site providing mail services, Web search
site, Clothing company, Bakery.
Technical Details: Think about the company as a Java application. The resource information
will be held in a database and the application will access the database through JDBC. Once the
application accesses the database, it takes the information and creates a well-formed XML document. (You can also create an XML Schema for the XML ﬁle and check its validity, but this is
optional.) A sister company will access the main company through http. Hence, using URL (or
URLConnection) the sister company will be able to access the XML ﬁle at a particular URL and
read it. The sister company can then display the XML as it is.
In the demo, you should be able to show cases where
1. The database tables: You need to have at least two tables with three-ﬁve entries in each table.
You should be able to add or delete to these tables.
2. Generate XML: You should be able to generate a well-formed XML ﬁle from the tables.
3. Check validity: Have an XML Schema and check that the ﬁle you generate is valid.
4. Obtain XML ﬁle: Have a Java application that requests this ﬁle and shows it on the screen
9 freelancers are bidding on average $161 for this job
Hi, I'm an experienced java developer, familiar with web and database technologies. Does the program need to run as a web app to provide the sister company access to the xml files?