Date of Award


Degree Name

Master of Science


Computer Science

First Advisor

Dr. Dalia Motzkin

Access Setting

Masters Thesis-Open Access


The objective of this study was to propose a design methodology to support a designed in mapping a conceptual model to a logical model. The system was created as a semiinteractive software to produce an optimal relational data model for a given database. The software was developed by combining a well known normalization method from a theory of relational data model which was presented by Codd and the ideas of new normal form which were presented recently by many researchers in the field of database design. The complete description of data objects and their associations are initially defined as a set of relations, along with each relation the dependicies are defined as constraints. Afterward a normalized schema is derived by the execution of the software under the consideration of a database designer.