SOLVED PROBLEMS
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)