This project is done on windows using workbench and idle. So the PROJECT.sql file is loaded into the localhost server and executed. Also, the python script is run on idle.

Changes made

• Added subclass attribute in parent class and its subclasses for the parent class to be modeled in one subclass(maintaining subclass integrity relation)
• Added a bill date attribute in prescribe_func_1 and prescribe_func_2 tables for calculating the associated bill costs and removing and adding test_id and id in prescribe_func_1 and prescribe_func_2 tables, respectively.