The conceptual schema of a database consists of concepts, the attributes related to a concept, how concepts relate to another (e.g. via foreign keys), etc. Note that the conceptual schema does not concern the storage details of the database (e.g. the conceptual schema might use number
while the physical schema might need a more specific data type, like integer
or bigint
; likewise, indices are not involved in the conceptual schema).