This assignment uses information available through the medical database shown below.  Looking at the information that can be retrieved indicates a fairly sophisticated database structure.  I want you to look at the information that is stored and determine the database structure that you might design to hold this information.

 

http://biblioline.nisc.com/scripts/login.dll

If you click on view database record you will see information from the database.

 

Assignment: Looking at this output, layout for me a possible structure of the database that would result in making it possible to display this information.