Comparison of Data Models


Problem 1. Consider the following relations given as relationship model-person(Name, City, AccNo),  deposit(AccNo, Balance).

Considering at least five dummy records the database given above, show how this relational model  can be  converted  into network  model  and hierarchical  model.

Solution. We consider that AccNo is unique in relation deposit and combination of Name and AccNo  is  unique  in  relation person  and  account  may  be a combined  account.

Sample data in hierarchical model

Source: Gupta Satinder Bal, Mittal Aditya (2017), Introduction to Basic Database Management System, 2nd Edition-University Science Press (2017)

Leave a Reply

Your email address will not be published. Required fields are marked *