Conceptual Schema

CONCEPTUAL SCHEMA

Once a database designer is aware of the data which is to be stored within the database, they must then determine how the various pieces of that data relate to one another. When performing this step, the designer is generally looking out for the dependencies in the data, where one piece of information is dependent upon another, i.e., when one piece of information changes, the other will also. For example, in a list of names and addresses, assuming the normal situation where two people can have the same address, but one person cannot have two addresses, the name is dependent upon the address, because if the address is different then the associated name is different too. However, the inverse is not necessarily true, i.e., when the name changes address may be the same.

Leave a Reply

Your email address will not be published. Required fields are marked *