Abstract:
Many methodologies exist that can make the database design process easier for both
designers and users. They vary from general design technique described in the literature to
commercial products whose aim is to automate the design process. CASE (Computer-aided
Software Engineering) packages provide the engineer with the ability to automate software
development.
CASE Tools are used in this project, in order to reduce the manual effort involved in
mapping ERDs onto relational model and generating the SQL code. The project is aimed at
taking input from the user in the form of ERD and then generating SQL code, after going
through all the stages of mapping and normalization automatically.