Give an alternative representation of bank information containing the same data as shown in figure but using

Question:

Give an alternative representation of bank information containing the same data as shown in figure but using attributes instead of subelements. Also give the DTD for this representation.

<bank> 

<account>

<account-number> A-101 </account-number>

<branch-name> Downtown </branch-name>

<balance> 500 </balance>

</account>

<account>

<account-number> A-102 </account-number>

<branch-name> Perryridge </branch-name>

<balance> 400 </balance>

</account>

<account>

<account-number> A-201 </account-number>

<branch-name> Brighton </branch-name>

<balance> 900 </balance>

</account>

<customer>

<customer-name> Johnson </customer-name>

<customer-street> Alma </customer-street>

<customer-city> Palo Alto </customer-city>

</customer>

<customer>

<customer-name> Hayes </customer-name>

<customer-street> Main </customer-street>

<customer-city> Harrison </customer-city>

</customer>

<depositor>

<account-number> A-101 </account-number>

<customer-name> Johnson </customer-name>

</depositor>

<depositor>

<account-number> A-201 </account-number>

<customer-name> Johnson </customer-name>

</depositor>

<depositor>

<account-number> A-102 </account-number>

<customer-name> Hayes </customer-name>

</depositor>

</bank>

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database System Concepts

ISBN: 978-0072554816

4th Edition

Authors: Henry F. Korth, S. Sudarshan

Question Posted: