Oops I missed your quote "You will also need to consider that it is highly likely that a IMS dataset contains several type of records and that you will need to create a sql table for each type of record."

Yes, I am in verge of DATA Modeling and Cobol guy sent me for 3 MENU screens and the segments each Menu screen is used, so based on segments used I was planning to Datamodel by

1. create SUPERTYPE based on common data and SUBTYPE based on uncommon data

2. Based on your comment, I have to create a SQL TABLE for each type of record in a IMS Dataset ?

However, I am considering this project as a project, where client has given me EXCEL SHEETS and UI Mock screens, build everything from scratch - your comments ? because I cant spend my time learning COBOL or HIERARCHIAL Data model of IMS.

So, any guidance on HOW TO Datamodel an IMS DB to RDBMS will be immense help ?