Lab 2 Spring 2001

The Problem

A drug company wants a database that will associate every product with a set of side-effects. Each product has a name and key field identifier and each side-effect has a description, severity level (1, 2, 3 or 4) (this varies from product to product), and a key field. Design a database that will serve to record this information (do not worry about other possible connections, this is a stand alone database). Write a program that will allow the drug company do update the side-effect and product list (add, edit and delete individual items or connections between a drug and a side-effect). You program should display all products in one window, all side-effects in another window. You should have a third window to display the side-effects associated with a drug. Each of these windows should have a menu that allows items to be added, deleted and edited in that window. All information should be displayed for each item in a window.